Conditional Format Font Style in Cell

[Edward]

In Excel 2003 changing the font colour when a certain value was reached was
easy. I have tried without succsss with Excel 2007. Okay to highlight the
cell but I don't want that. Can anyone help?

TIA

Ed

 

[Bernard Liengme]

Select cell(s)
On Home tab; click Conditional Formatting down arrow
Select New Rule
Select Use a Formula... (last item)
Enter formula such as $A$1>10
Click Format button and set font colour as in XL 2003
best wishes

 

[Edward]

Thanks, Bernard.

I have tried again since and it works fine with "Conditional Formatting\\Top
and Bottom\\More rules\\Format only cells that contain... It is the
plural "Cells" that fooled me.

Thanks for your help.

Ed