'Conditional Formatting is populating when I don't have the value in the cell
I am having an issue on column O shows green when I added conditional formatting but it suppose to show when there is a value greater than 30. There is no value in the cell but it's showing green.
How can I have the conditional formatting but also not have t populate green until there is a value
Solution 1:[1]
You do not need to change your formulas.
As seen in my Example Image link above, do the following:
Create two conditional formatting rules for the range of cells.
The first rule is for blanks and has no actual change in fill color. Check the "Stop If True" box. If a blank or "" is found it will change the formatting to the standard formatting.
The second rule is for cell values greater than 30. If a blank or "" is not found it will go to this second rule which actually changes the fill color when the value > 30.
The order of the rules matters. In this order, the blanks are dealt with first and the values over 30 are dealt with second.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 | cybernetic.nomad |