View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
brewster56 brewster56 is offline
external usenet poster
 
Posts: 24
Default Conditional Fromat Question

In C19, I have that cell formatted as a Percentage. I wanted to add
Conditional Formatting as follows:

=$C$19=0 (Format set to the color blue)
=$C$190 (Format set to the color red)
=$C$19<0 (Format set to the color green)

I am attempting to have the color change as the percentage value goes
up/down throughout the month. The percentage changes in C19 based on calc
from other fields. It seems to work except that I start with the 3 rules
above, but end up with dozens of the same rule as C19 changes. Apparently it
appends a rule each time the C19 changes ???