Conditional Formatting Forces Ugly Font

Hi there,

My entire worksheet is in Geneva, 10-point.

However, when I attempt to modify any Conditional Formatting rules, I am forced to have all of those cells be Cambria, 10-point. Any option to change this is greyed out.

How can I stop it from forcing Conditional Formatted cells to Cambria?

Thanks,
Ben

It appears that I don't! That could explain things. How do I change the default font for the worksheet, so it doesn't default to Cambria?

(Changing everything to Times New Roman manually still results in it being changed to Cambria when I do conditional formatting.)

If you want a font like Geneva, change the style Normal to font Tahoma, and select all cells (Cntrl+A) and change the font to Tahoma, then proceed from there.

As I said, conditional formatting does not (cannot) change fonts.

Has anyone found a solution to this issue? It seems to be a bug that started in Excel 2007 and continues into Excel 2010.

Issue: When you have an existing Conditional Format and you change the font color, the font type changes to Cambria. The only work around is to delete the conditional formatting element and set the font color like you want it the first time. When you are fiddling with the right look, this is an annoyance.

The only solution is to get it like you like it, then delete the conditional format and re-add it. If you ever edit the font color again, it changes the font back to Cambria again.