Conditional Formatting

[Richard]

When using conditional formatting, I would like to be able
to change the font - though this is greyed out. Is there a
way round this, or am I just doing something wrong?

Thanks

Richard

 

[EZ Money]

It clearly states on the Font tab for conditional formatting that you can
set Font Style, Underline, Color and Strikethrough. Fonts and Sizes cannot
be set in conditional formatting. This can probably be changed via VBA.

 

[Gord Dibben]

Richard

Note on the dialog screen in CF>Format>Font: you can change font style,
underline, color and strikethrough.

That's it. You are doing nothing wrong. Font type cannot be changed.

Gord Dibben Excel MVP - XL97 SR2 & XL2002

 

[Mathew]

Hi Richard,
I have found a way that suits me for conditionally
applying font formats.
I got the source information for this from
http://www.mvps.org/dmcritchie/excel/excel.htm
Very Good Site. DM often offers advice in this group.

I have a cell that I have conditionally formatted for
different fonts, dependant on the value/formula result of
another cell, as follows, its a bit like having up to 3 if
statements!

Conditional Formatting applying to B3 ( to copy down later)
condition1
Formula is =A3="" Then Format Font,
condition2
Formula is =A3<>"" Then Format Font

This may be extended further,
but it says if A3 Blank then font Red
or if A3 not blank then font Blue

Hope this helps
Mathew