SOLVED

Conditional Formatting

Copper Contributor

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% didn't. Another row having the 20% did turn green but I am not sure the reason but this one does not turn green. Would you please me on this. Thank You 

 

DjabiaK_0-1685020538926.png

 

here is the formatting rule 

 

DjabiaK_1-1685020827156.png

 

2 Replies
best response confirmed by DjabiaK (Copper Contributor)
Solution

@DjabiaK 

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
1 best response

Accepted Solutions
best response confirmed by DjabiaK (Copper Contributor)
Solution

@DjabiaK 

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%)

View solution in original post