change font for cells containing Formulas

[Sabina00]

Hi. I am trying to use a conditional formatting rule to change font color of a cell based on 3 criteria. See attached.

Example data below. Also attached file. Some cells contain formulas and some contain hard coded values.


January February March
2,000 1,000 726
29,999 29,722 31,409
199,143 187,233 201,636
2,561 1,146 3,328
90,721 (11,253) 50,402


3 example results:

1.) cells containing hard coded values reflect font color as pink
2.) cells containing an average formula (each row different row number) make yellow ' =AVERAGE($E8:$M8) '
3.) cells containing a run-rate make font green (each row different number) ' =$M8 '


Thank you!

[AliGW]

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.