J
John
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.
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.