can font color be controled in an IF statement

C

Confused Rookie

I'm doing a simple % calculation. If the returned % is greater than 100%, I
want the % to be displayed in red so it's noticable. Otherwise I just want
the % displayed in black font. Can this be done?
 
M

Mike H

Hi,

You can do that with conditional formatting. Set a conditional format of
cell value is >1 and select a colour, format the cell as percentage

Mike
 
C

Confused Rookie

Excellent, worked great and was easy, thanks-

Mike H said:
Hi,

You can do that with conditional formatting. Set a conditional format of
cell value is >1 and select a colour, format the cell as percentage

Mike
Click to expand...
 
G

Gord Dibben

Format>Conditional Formatting can be used in this case.


Gord Dibben MS Excel MVP
 
Top