Forum Discussion
Conditional Formatting with Percentages
I appreciate all your help!
3 Replies
Try the following:
Select rows 2 to 15.
On the Home tab of the ribbon, select Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula
=MAX(IFERROR($AL2:$AO2,0%))>=PERCENTILE.INC(IFERROR($AL$2:$AO$15,0%),95%)
Click Format...
Activate the Fill tab,
Select a color.
Click OK, then click OK again.
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%.
I interpreted your question differently. Change the formula to
=MAX(IFERROR($AL2:$AO2,0%))>=95%
