Mar 25 2021 08:36 AM - edited May 23 2021 11:29 AM
I appreciate all your help!
Mar 25 2021 09:20 AM
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.
Mar 25 2021 10:01 AM
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%.
Mar 25 2021 10:15 AM
I interpreted your question differently. Change the formula to
=MAX(IFERROR($AL2:$AO2,0%))>=95%