You can't control the format with formulas.

However, you can use "Conditional Formatting" on the cells containing such
types of formulas, to change the cells format. depending on the return of
the formula.
--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"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