Conditional Format Font Style in Cell

  • Thread starter Thread starter Edward
  • Start date Start date
E

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
 
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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Advanced conditional formatting 1
Conditional Formatting 3
Conditional Formatting 1
Count of Font Format 1
2nd condition in a conditional formatting not working 9
Conditional formatting based on length of the cell contents 5
copy conditional formatting using built in feature? 1
Question about conditional formatting of zeros in Excel 0

Back
Top