Conditional formatting displaying incorrectly
Posted by Mike Winters on January 22, 2002 11:12 AM
I have the following conditional format applied to a range of cells, al in the same column:
=(X85)>=36 (formats cell color to green)
=(X85)>=30 (formats cell color to yellow)
=(X85)>=23 (formats cell color to red)
The problem is that it no longer correctly displays the color, rather, it seems to set them all to green when I put new data into the cell. What could I have changed in the last month or so since I created the formula that stops it from working now?
Sincerely,
Mike Winters
Posted by e.h.m. on January 22, 2002 11:52 AM
You must write the following conditional format:
=(X85) BETWEEN 30 AND (formats cell color to yellow) =(X85) BETWEEN 23 AND 30 (formats cell color to red)
Posted by Mark W. on January 22, 2002 11:56 AM
See the Help Index topic for...
Apply conditional formats to cells"
Its 4th Tip states...
"If you specify multiple conditions and more
than one condition is true, Microsoft Excel
applies only the formats of the first true
condition."
I have the following conditional format applied to a range of cells, al in the same column:
Posted by Steve Hartman on January 22, 2002 12:00 PM
What is in X85? Could it be a cumulative total of some kind (perhaps days?) that in the last month or so has become bigger than 35. If that's the case, the first condition will always be true and the cell will always be green.
Posted by Mike Winters on January 22, 2002 1:32 PM
To answer a previous question, X85 is the cell (in that instance). The cell data is a number between 0 an 40, which I input. The way I have it set up, it should go through the higher numbers first, so if the first condition is false, it should fall through to the next, and so on, which it did before, but does not now. Does this shed any more light on the issue?
Sincerely,
Mike Winters
United States Army
