K
Ken Dickens
Does anyone have a method that allows you to sort by Text
Color or by Background Color?
Color or by Background Color?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
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?
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)
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)
K
Ken Dickens
Thx Mark & Bob, Great info on that site. kd
G
Guest
Your Welcome