Macro for sorting color data
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. |
Macro for sorting color data
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. |
Macro for sorting color data
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. |
All times are GMT +1. The time now is 10:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com