sort question

H

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
 
J

JE McGimpsey

Harvey Waxman said:
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.
Click to expand...

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