Conditional formatting using cell styles in Excel 2007?
Fresh3 days ago
Mar 15, 20262345 viewsConfidence Score0%
0%
Problem
Excel 2007 has added support for cell styles, which I find very useful. I love it when I can change formatting in one place and the change propagates throughout the spreadsheet. I also love conditional formatting. Can the two be combined? Can I conditionally apply a cell style?
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Conditional formatting using cell styles in Excel 2007?
Low Risk
You can't conditionally apply a style, but you can conditionally remove it. If you format the cell with the style that you ultimately want, then depending on the situation, you can then clear that style with the conditional formatting.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix