Hi,

You saw correctly. Here is an example:

[<10][Red]"OK";[Yellow]"NOK"

Select the cells to format. To set this up choose Format, Cells, Number
tab, Custom and enter the above on the Type line.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"daniel ron" wrote:

Hi all,
I have the problem to format a cell directly within an IF Formula.
I think I have seen once something similar to IF (A1<10; [red]ok;
[yellow]NOK), so without using a conditional formatting.
Can any of You help me or let me know I am crazy?
thank You in advance
Daniel