Sort Column by Text Color or BackGrd Color

K

Ken Dickens

Does anyone have a method that allows you to sort by Text
Color or by Background Color?
 
G

Guest

Darn! It's so cold here in Massachussetts that my fingers hit the wrong key.

Check out Chip Pearson's page.

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

Good Luck,
Mark Graesser
(e-mail address removed)

----- Ken Dickens wrote: -----

Does anyone have a method that allows you to sort by Text
Color or by Background Color?
 
B

Bob Phillips

Ken,

The principle is to create a UDF to calculate the Colorindex and add it to
an adjacent column, and then sort by that column. Chip Pearson shows the
technique at http://www.cpearson.com/excel/SortByColor.htm

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - counting cells by colors and names to it in two different rows. 0
Background stays when sorting 2
How to filter rows data based on background color of individual cells 1
Word Globally Changing Specific Color Highlight to Background Color 0
VBA- Excel Programming:- 0
Sorting by color of font 4
How to type each letter of the alphabet automatically in a specific color in Word? 0
sort by colors 4

Top