ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Conditional Formatting Font Change (https://www.excelbanter.com/excel-discussion-misc-queries/247927-conditional-formatting-font-change.html)

Hugh

Conditional Formatting Font Change
 
In Excel 2007 I have applied Conditional Formatting to a range of cells (B1
to B100) so that the font colour changes to green if the corresponding cell
in the range D1 to D100 displays "Accepted". Trouble is, Excel has made the
font "Cambria". The background / normal cell font is Arial. I cannot
control the font in Conditional Formatting, but Excel seems to want to change
it for me. I've never used Cambria.

What's going wrong?

Eduardo

Conditional Formatting Font Change
 
Hi,
Go to conditional formating, manage rules, choose your formula and see if it
has not Cambria assigned

"Hugh" wrote:

In Excel 2007 I have applied Conditional Formatting to a range of cells (B1
to B100) so that the font colour changes to green if the corresponding cell
in the range D1 to D100 displays "Accepted". Trouble is, Excel has made the
font "Cambria". The background / normal cell font is Arial. I cannot
control the font in Conditional Formatting, but Excel seems to want to change
it for me. I've never used Cambria.

What's going wrong?



All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com