Forum Discussion

vmangalkar's avatar
vmangalkar
New Member
2 years ago

Conditional Formatting for highlighting cells having value 100% or greater

Hello Everyone,

 

I have one table like below, where in last column I want to highlight a cell having % greater than or equal to 100.

I have set the criteria like below using conditional formatting and it's showing output as expected for cells having 100%+ values but for 100% it's not working even after using '>=' operator.

 


Looking forward to get help here. Thanks in advance!

1 Reply