Forum Discussion
Solved
Conditional Formatting
Good Morning, Need help on this. I applied a conditional formatting on column E based on the threshold level listed in Column I . But it seems to have worked but on row, the one listing the 20% di...
I suspect that the value that remains white is actually between 20% and 21%, for example 20.4%.
Try changing the formula for the middle rule to
=AND(E5>20%,E5<=40%)
I suspect that the value that remains white is actually between 20% and 21%, for example 20.4%.
Try changing the formula for the middle rule to
=AND(E5>20%,E5<=40%)
HansVogelaar , I changed to formula to the one you suggested, and it worked. Thank You so much