Re: Font coloring function

From: Jason Morin (jason.morin_at_us.exel.com)
Date: 04/01/04


Date: Thu, 1 Apr 2004 09:36:32 -0800

One way is via custom formatting. Select the cell, press
Ctrl+1, Number Tab, click Custom, and key in:

General;[Red]-General;0;@

For more info on custom number formatting, check out:

Custom Number Formatting in Microsoft Excel:
http://support.microsoft.com/default.aspx?
scid=/support/excel/content/formats/default.asp

HTH
Jason
Atlanta, GA

>-----Original Message-----
>I'm looking for a way to change the font color of a
number.
>
>something like this;
>
>=IF(A1<=0,"font color RED",A1) but I know that's not how
>you do it, can anyone help?
>
>thx
>.
>