How To Sort/Group All Highlighted

buDDHA - Aug 27, 2010 at 11:15 AM
 Ray - Aug 27, 2010 at 05:47 PM

I was wondering if there's a way to group all the highlight cells from the unhighlighted cells.


1 reply

How is the highlighting being done? Manually or via a macro?
If a macro is doing it then:
Add a column and place a value that corresponds to the highlight. So, for all rows in Yellow, put the word yellow,for Red , put red. The foreground color of the cell should be the same color as the background so you wont see the word. Then group by this new column. All the colors will be sorted and grouped together.

Same could be done manually of, course.