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.

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.

There is a commercial alternative from yours truly...
http://www.officeletter.com/blink/specialsort.html
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"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.