Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 ??? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional maybe IF question | Excel Discussion (Misc queries) | |||
Change fromat from number to text | Excel Discussion (Misc queries) | |||
Cell Fromat Protection | Excel Discussion (Misc queries) | |||
Time Display in a Stop Watch fromat | Excel Discussion (Misc queries) | |||
conditional sum question | Excel Worksheet Functions |