Excel - Top Quartile

[jrobin5881]

Is there a way through either VBA or conditional formatting to higlight those rows that are in the top quartile of the list?

For example I have one hundred rows worth of data and sorted based on values in column X. I want the top 25 rows to be highlighted in yellow automatically.

Of course the number of rows will vary based upon the data set returned. So it could be 100 or 1000 etc.

 

[mintjulep]

Use the PERCENTILE() function in conjunction with conditional formatting.

 

[jrobin5881]

MintJulep,

Thanks. Worked perfect. In case it can help someone else here's what I did:

In cell H3 i put this formula in =PERCENTILE(E3:E1000,0.75)
and then I used conditional formatting and put this in the cell: Cell Value is Greater Than $H$3 and I have the box shade red when it finds the condition met.

Thanks again.