Search code examples
excelformattingexcel-2007conditional-formatting

Excel 2007 - Conditional Formatting: Font reverts to Cambria


Whenever I use conditional formatting the font changes to Cambria (size 10 or something). I can't change the font nor its size using the [home, conditional formatting, manage rules, edit rule, format, 'font'] tab. It's all greyed out! It looks like a bug? I've seen posts on this on the web but no answers. What now?

(Ps I'm using Windows XP SP2. We're going to upgrade to Windows 7 in a few months, which might make the problem go away.)


Solution

  • this may be a little late, but I found this site when searching for a solution, so maybe someone else can benefit from the information.

    Office 2010 also seems to disable Conditional Formatting while you have Tracking enabled. In my case, disabling tracking fixed the problem. You can then create the conditional formatting and re-enable tracking.

    Hope this helps someone out!

    G