J
jegal76
Is there a formula that will allow me to sort a column based on the
background color?
Thanks,
Jaime
background color?
Thanks,
Jaime
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.
J
Jim Cone
Jaime,
My Excel add-in "Special Sort" will sort by font color or cell color.
It provides 12 different ways to sort not available in the Excel sort utility.
Comes with a Word.doc install/use file.
It is free upon email request - remove XXX from my email address.
Jim Cone
San Francisco, USA
[email protected]
"jegal76"wrote in message
Is there a formula that will allow me to sort a column based on the
background color?
Thanks,
Jaime
My Excel add-in "Special Sort" will sort by font color or cell color.
It provides 12 different ways to sort not available in the Excel sort utility.
Comes with a Word.doc install/use file.
It is free upon email request - remove XXX from my email address.
Jim Cone
San Francisco, USA
[email protected]
"jegal76"wrote in message
Is there a formula that will allow me to sort a column based on the
background color?
Thanks,
Jaime
B
Bob Phillips
Not a formula, but there is a technique here
http://www.xldynamic.com/source/xld.ColourCounter.html#sorting
--
HTH
RP
(remove nothere from the email address if mailing direct)
http://www.xldynamic.com/source/xld.ColourCounter.html#sorting
--
HTH
RP
(remove nothere from the email address if mailing direct)
B
Bob Phillips
Not a formula. See here
http://www.xldynamic.com/source/xld.ColourCounter.html#sorting for a
technique
--
HTH
RP
(remove nothere from the email address if mailing direct)
http://www.xldynamic.com/source/xld.ColourCounter.html#sorting for a
technique
--
HTH
RP
(remove nothere from the email address if mailing direct)