View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default 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