Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Excel - Top Quartile

Status
Not open for further replies.

jrobin5881

Technical User
Mar 10, 2004
228
US
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.
 
Use the PERCENTILE() function in conjunction with conditional formatting.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top