can font color be controled in an IF statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
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...
 
Back
Top