Yonnie,
If you want to change font color in cell A1, first change the font color to
blue.
Type "0" (zero) in cell A1. Along the top of your excel you will see an A
with a color under it. Typically it is black, select the down triangle and
pick the shade of blue that you want. Your "0" (zero) should change color.
Now select cell A1, and select "Format", select "Conditional Formatting".
Condition 1 -
Cell Value Is, select "less than", 0 (zero).
Select the "Format" button, select color, "red", select "OK"
Select "OK"
Or
After you create the first condition, selcet the "Add" button.
Condition 2-
Cell Value Is, select "greater than", 0 (zero).
Select the "Format" button, select color, "blue", select "OK"
Select "OK"
Either way will work. Good luck.

hth Dennis


"Yonnie" wrote:

I am new to this - I would like to know how to change the font color
conditional to a formula result.
for example =if((A1<than 0,"font red", "font blue")
I am familiar with some very simple formulas - but I would like to
understand how to perform the above.
Please don't laugh - but I would like to be directed to the right place to
learn how to do it?
Yonnie