formulas to change font
On Fri, 23 Jan 2009 22:06:01 -0800, 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
You can't do it with a formula. Others have written about Conditional
Formatting; but you can also use custom formatting of the number:
Format/Cells/Number/Custom Type:
[Blue]0.00;[Red]0.00;[Blue]0.00
or
[Blue]General;[Red]General;[Blue]General
--ron
|