Sort colorwise

Dear All,

How to sort if i have different colored rows/ cells , etc...... ?
e.g. I want to select rows of red color among other colored rows........

There is no intrinsic function to sort by fill color, but it can be done with a user defined function. I'm sure one of the fat brains around here could spit out a code snippet that would work.

Hello satpute,

Have a look a Chip Pearson's code to this. Click on the link below...

Sort by Color

Sincerely,
Leith Ross