Quote:
Originally Posted by gfnut
I am trying to color the 3 highest #'s and ties in each column at the touch of a button. Can I do this with custom formatting or do I have to write a macro? Any help would be appreciated.
Attachment 23843
|
HIGH-LIGHT your rows..
Choose Conditional Formatting....
Choose Highlight Cell Rules---EQUAL TO
Then do this for 1-2-3 seperatly