IF-function

L

Leif

Hi,
is it possible to get the answers in an IF-function in different colors? For
instance, =IF(A1<100,"Yes","No") where the No answer is in red?

I know I can use Conditional formatting but I´d like it within the
IF-function.

Regards
Leif
 
P

Peo Sjoblom

First select the cell with the formula, do format>conditional formatting,
formula is and use

=$A$1>=100

click the format button and select red fonts, click ok twice
 
L

Leif

Thanks Peo, but is it not possible to format within the If-function? And by
the way, could you please send me the Solver example you had used?

Thanks a lot.
 
P

Peo Sjoblom

No it is not possible within the if function, you have to select the cell
with the if function,
do the conditional formatting and use the opposite condition since you
wanted no to be red..
Attached file sent
 
Top