Thread: Font Color
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Pinks
 
Posts: n/a
Default Font Color

I would like to be able to change the color of a value within a cell
depending on whether this is a negative or positive value. Thus - if my
calculation reults in a minus value e.g -2.7, I would like this displayed in
Red. If it is positive value, say 10 then I would like it displayed in green.
Any help or advice would very much appreciated


Pinks