jrobin5881
Technical User
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.
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.