Fonts with IF Statements

  • Thread starter Thread starter Farley Granger
  • Start date Start date
F

Farley Granger

Is there a way to change the color of a font in an IF function that uses
text.

For example

=IF(B4>100,"Over","Under")

Can I make the OVER in Green and the UNDER in Red?

Thanks

Dennis
 
One way

select the cell with the formula, do format>conditional formatting,
formula is and in the box put

=$B$4>100

click the format button and select fonts, select green as colour, then click
OK,
now click Add,

formula is and use

=$B$4<100

click format and select red font colour, click OK twice
 
Back
Top