As far as i know you can't use that notation to colour a cell in a an IF
formula, you would have to use conditional formatting or use code for a
SELECT CASE statement in the worksheet change or calculation event.

daniel ron;230774 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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=64489