Use color in a IF formula
 

hi
i would like to change the color of my text, for different condition in a IF
formula. I know that it's posible but a just don't remember the syntax.
ex: =if(A1=100;(red)"To much";(green)"To low")

Thanks

No. But you can do conditional formatting that says if your cells says "too
much", to make it red.
Format--Conditional Format...
************
Anne Troy
www.OfficeArticles.com

"Estyl" wrote in message
...
hi
i would like to change the color of my text, for different condition in a
IF
formula. I know that it's posible but a just don't remember the syntax.
ex: =if(A1=100;(red)"To much";(green)"To low")

Thanks