sort question

[Harvey Waxman]

Is it possible to sort based on the color of text in a cell? I have done
conditional formatting to more easily identify cells of interest and it would
be great if I could get them all together.

--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me

 

[JE McGimpsey]

Is it possible to sort based on the color of text in a cell? I have done
conditional formatting to more easily identify cells of interest and it would
be great if I could get them all together.

The easy answer to your question is "yes". See

http://cpearson.com/excel/SortByColor.htm

However, when you throw Conditional Formatting into the mix, the
answer's "no". The results of conditional formatting aren't exposed
either to the worksheet or to VBA.

One workaround: Use a helper column to evaluate the same conditions as
CF is using to come up with a value, then sort on that value.

 

[Harvey Waxman]

One workaround: Use a helper column to evaluate the same conditions as
CF is using to come up with a value, then sort on that value.

So obvious! Thanks once again. Wonderful group.

--
Harvey Products makers of Dinghy Dogs
The Boater's Best Friend
http://www.dinghydogs.com
Ladies' handbags and accessories
http://www.deducktibles.com
Remove thefrown to email me