Hi Tufail,

There is no native support for sorting by conditional format colours.

Perhaps, you could add a support column, containing an expression based on
the CF condition, and sort the data using the support column as the primary
sort key.


---
Regards,
Norman



"Tufail" wrote in message
...
hi there,

i want creat a macro that could sort my data by color, each cell has
conditional formatting setup, colors i am using red, green, blue.

really thanks in advance.