By adding two conditional formats
With A3 selected use: Format | Conditional Format
"Cell value is" - "Equal to " - "Increase" ----- and set the font colour
Now add the second
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Sam" wrote in message
...
I have a the following formula in A1 cell =if(Logic_test, A2,A3).
In A2 I have "increase" in red font and in A3 I have "Decrease" in blue
font. But when the value printed in A1 it is black no matter what. How can
I
make the format (mainly color of the font) of A1 to be same as A2 or A3?

<redincrease</red