Conditional Formatting with Percentages

Copper Contributor

 

I appreciate all your help!

 

 

3 Replies

@mvargas 

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.

@Hans Vogelaar 

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%. 

EXCEL_4jSleSmpBV.png

 

 

@mvargas

I interpreted your question differently. Change the formula to

 

=MAX(IFERROR($AL2:$AO2,0%))>=95%