Forum Discussion
I'm not sure why Conditional Formatting isn't working correctly
Hello, I hope you are all well. I'm having an issue with a worksheet and the Conditional Formatting I set up. I have the formatting set to turn the cell: Red if the value in the cell is less th...
That's since value of the blank cell is equivalent to zero, 0.85 is greater than zero, green condition triggers the color and next rule is not checked. You shall change (>0.85 and <>0 ) for this rule
I thank you very much for replying. I was able to get it to work properly with Peter's suggestion.SergeiBaklan