Change Font Color With "If" Function

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

How do I change font color in a cell depending on the
result of an "If" statement?

For example if the result of this formula in cell G6
returns "Review" I want the font to be Red, or if the
result is "On Target" the font is Green.

=IF(F6>0,"Review","On Target")

Tks
 
Mike said:
How do I change font color in a cell depending on the
result of an "If" statement?

For example if the result of this formula in cell G6
returns "Review" I want the font to be Red, or if the
result is "On Target" the font is Green.

=IF(F6>0,"Review","On Target")

Tks
Click to expand...

You need Conditional formatting on the Format menu.
You base the conditional formatting on either the cell value or a formula.
In your example, you would make the default font colour green. Then apply a
conditional format (red font) either if the cell value was equal to
"Review", or with the equation =(F6>0).
 
-----Original Message-----
How do I change font color in a cell depending on the
result of an "If" statement?

For example if the result of this formula in cell G6
returns "Review" I want the font to be Red, or if the
result is "On Target" the font is Green.

=IF(F6>0,"Review","On Target")

Tks
.
Click to expand...


You have to use the conditional formating for that

In the target cell you type the formula =if(xx,ss;zz) then
selct in Under Format - Conditional formating - if cell
a "greater or equal than" and specify format of cell (font
+ colour) then OK

Regards
Franck
 
Back
Top