Font Style - Conditional Formatting

**Edsaid** · 10-06-2010, 08:59 AM

Excel 2007 - Windows 7 Ultimate.

Can anyone tell me why I am unable to select (presently greyed out) font size and colour when using Conditional Formatting for a single cell?

Is there a way to make these choices available?

TIA for any help.

**Marcol** · 10-06-2010, 09:08 AM

As far as I know you can't change Font and Font Size with conditional formatting.

You can change Font Style, Colour, Underline and Effects.

**Edsaid** · 10-06-2010, 05:34 PM

Thanks Marcol.... Disappointing, but pretty well what I suspected.

**Marcol** · 10-06-2010, 05:42 PM

You might be able to achieve what you are after using VBa, and perhaps use this as an User Defined Function (UDF).

We would need to know what you want to resolve.