|
Posted to microsoft.public.excel.misc
|
|
|
Sorting by Color in Excel 2003
See http://www.xldynamic.com/source/xld....r.html#sorting
--
HTH
Bob
"John" wrote in message
...
I am not sure where this question belongs so I thought I would enter it
under
general questions. I have a sheet with 3,245 rows. There are blocks of
data
that are highlighted in yellow. The data in the row always starts in the A
column and ends in the F column. I need to sort the data so all of the
yellow
blocks are together.
A1:F1 contain the tiles of my cells, then rows A2:F3 contain yellow filled
data then I have no colors until A30:F30 etc.... down to the end of the
sheet. I would like to have all of the yellow colored cells together.
I know Excel does not do this on its own, but I was told thatt here is a
way
to create something that will tell it to sort by color.
|