View Single Post
  #1   Report Post  
CoZ
 
Posts: n/a
Default Macro to sort by cell colour

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