formatting the Cell color directly in an IF formula

  • Thread starter Thread starter daniel ron
  • Start date Start date
D

daniel ron

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
 
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.
 
Back
Top