Conditional Format Font Style in Cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Edward - 25 Nov 2007 12:03 GMT

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

Reply to this Message

Bernard Liengme - 25 Nov 2007 13:10 GMT

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

Signature

Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

> 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
[quoted text clipped - 3 lines]
>
> Ed

Reply to this Message

Edward - 25 Nov 2007 23:29 GMT

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

> Select cell(s)
> On Home tab; click Conditional Formatting down arrow
[quoted text clipped - 10 lines]
>>
>> Ed

Reply to this Message