Macro for sorting color data

[Tufail]

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.

[Norman Jones]

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" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Jim Cone]

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" <[email protected]>
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.