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 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" <[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.
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks