hello all,
i've attached a chart for reference.
but, essentially, i was wondering what the easiest way of highlighting the top 5 values in each column is.
hello all,
i've attached a chart for reference.
but, essentially, i was wondering what the easiest way of highlighting the top 5 values in each column is.
Last edited by Apelcius; 10-24-2011 at 05:43 PM.
--Apelcius--
Learn. Share. Rinse, Repeat.
Enter this conditional formatting formula in cell B3, then fill down and across.Please Login or Register to view this content.
Last edited by tlafferty; 10-24-2011 at 05:34 PM. Reason: started at the wrong column
If your question has been satisfactorily addressed, please consider marking it solved. Click the Thread Tools dropdown and select Mark thread as solved.
Also, you might want to add to the user's reputation by clicking the star icon in the lower left corner of the post with the answer- it's why we do what we do...
Thomas Lafferty
Analyst/Programmer
holy majolies.... that was fast, AND exactly what i was looking for... purely awesome...
thanks
Glad I could help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks