New Contributor

# Conditional Formatting with Percentages

I am working with Excel 2019 with Windows 10.

I have a Workbook that is full of data but I need the entire row highlighted based on the top 5% of the percentages in the last 4 columns of my sheet (AL:AO) *** I attached a sample of the data that I have.

The rest of my sheet is full of number data but I am not sure how to apply it without taking the numbers from the other columns.  I need that when there 95%-100% in the those columns to highlight the entire row. I hope that makes sense

3 Replies

# Re: Conditional Formatting with Percentages

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.

# Re: Conditional Formatting with Percentages

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

# Re: Conditional Formatting with Percentages

@mvargas

I interpreted your question differently. Change the formula to

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