If you are using Excel 2003 you can NOT have more than 3 conditions...

How do you find out that you have more than 3?

Conditional Format will depend only on the result of the formula in C19...
it does not depend on the cells it depends on.

"brewster56" wrote:

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 ???