Changing result color

[Gene L.]

Need help (again)

I have an Excel 2007 worksheet column that contains a calculated average of some daily postings. Is there a way to change the font color of the results when the average exceeds a certain number ?

The calculation of the average is fine but I would like to have high results really stand out when the average exceeds 150.

Thanks for your help.

Gene L.

 

[trip_to_tokyo]

Home / Styles / Conditional Formatting / New Rule . . . / single left hand
click on:-

Format only cells that contain

- to highlight it.

Change to:-

greater than

100 (for example, or the number that you want).

Format . . . / Font tab / change the Color: field to the one that you want /
OK / OK

The above should give you what you want.

If my comments have helped please hit Yes.

Thanks!

 

[Gene L.]

OK I Have it - Great answer - Thank you so much.
Gene L.