Fonts with IF Statements

[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

 

[Peo Sjoblom]

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