IF-function?

[dervy]

Hello,

I've a problem whit the if-function in excel.

If(20<30;true;false)

Is there a way to put the true value (a number) and the false value
(also a number) in diffrent collors? Not whit VBA please (that way I
know!)

Thanks a lot!
Dervy

 

[Arvi Laanemets]

Hi

At start, you can simplify your formula
=(20<30)
And am best, let result be displayed as TRUE/FALSE (when cell was formatted
as General, Excel will format this automatically this way, after you enter
the formula).

You can use conditional formatting, to format the cell accordingly some
conditions, p.e. text color will be blue when cell value is TRUE, and red
when cell value is FALSE.