Forum Discussion
mvargas
Mar 25, 2021Copper Contributor
Conditional Formatting with Percentages
I appreciate all your help!
mvargas
Mar 25, 2021Copper Contributor
It didn't work.
I need to highlight Greater or Equal to 95% if its in any of the columns (AL-AO)
Just how it looks in the second green highlighted row.
This highlighted some that are below the 95%.
HansVogelaar
Mar 25, 2021MVP
I interpreted your question differently. Change the formula to
=MAX(IFERROR($AL2:$AO2,0%))>=95%