Re: Font coloring function
From: Jason Morin (jason.morin_at_us.exel.com)
Date: 04/01/04
- Next message: Frank Kabel: "Re: Reference a cell value in a vlookup function"
- Previous message: Michelle: "Re: Reference a cell value in a vlookup function"
- In reply to: Roger R: "Font coloring function"
- Messages sorted by: [ date ] [ thread ]
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
>.
>
- Next message: Frank Kabel: "Re: Reference a cell value in a vlookup function"
- Previous message: Michelle: "Re: Reference a cell value in a vlookup function"
- In reply to: Roger R: "Font coloring function"
- Messages sorted by: [ date ] [ thread ]