Macro to sort by cell colour

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change cell font color if time is> by 15 minute intervals upto 2hr 5
sort column by colour 3
Sort data separated by commas 4
how do I sort a column with several categories (ie red and blue) 1
how to update certain text in a cell according to thecell colour 1
EXcel 2007 - Unable to sort by font and cell colors 1
Excel 2007 conditional formatting & cell colour. 2
auto change cell text colour resulting from a condition 2

Top