Hey everyone,

I'm sure I saw a Macro once, that allowed me to sort by font colour.

For instance, all negative values are red, and I wanted to sort by all the
red values in any particular order.

Could I do a sort, using a macro, by cell colour. For instance a worksheet
contains rows of red blue, and yellow. If I wanted to see all yellow, what
would I do?

Thanks in advance for your time and help.
Andrew

Hi
see:
http://www.cpearson.com/excel/SortByColor.htm

--
Regards
Frank Kabel
Frankfurt, Germany


CoZ wrote:
Hey everyone,

I'm sure I saw a Macro once, that allowed me to sort by font colour.

For instance, all negative values are red, and I wanted to sort by
all the red values in any particular order.

Could I do a sort, using a macro, by cell colour. For instance a
worksheet contains rows of red blue, and yellow. If I wanted to see
all yellow, what would I do?

Thanks in advance for your time and help.
Andrew