View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default Excel 2007 Conditional Font Color How To?

In the same way as before with a custom format such as
[green]0.00;[red]0.00;0.00
Home | Number ; click the launcher (arrow next to text "number")
open the Custom dialog and enter your custom format in the box
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"M" wrote in message
...
How do I do conditional Font Colors (red negative, green position) like I
use
to be able to do before Excel 2007 - in this case I don't want to use the
fancy conditional cell formating or icons, just make the font color value
conditional.

M