Sorting by cell Color
I have a list of names in a spreadsheet and have color-coded certain ones. Is there a way to sort by the color of the cell or row? Thanks, Ted -- t2true ------------------------------------------------------------------------ t2true's Profile: http://www.excelforum.com/member.php...fo&userid=3877 View this thread: http://www.excelforum.com/showthread...hreadid=395445 |
Ted,
One way - see my post here... http://makeashorterlink.com/?F3C053B9B Jim Cone San Francisco, USA wrote in message ... I have a list of names in a spreadsheet and have color-coded certain ones. Is there a way to sort by the color of the cell or row? Thanks, Ted t2true |
See http://www.xldynamic.com/source/xld....r.html#sorting
-- HTH RP (remove nothere from the email address if mailing direct) "t2true" wrote in message ... I have a list of names in a spreadsheet and have color-coded certain ones. Is there a way to sort by the color of the cell or row? Thanks, Ted -- t2true ------------------------------------------------------------------------ t2true's Profile: http://www.excelforum.com/member.php...fo&userid=3877 View this thread: http://www.excelforum.com/showthread...hreadid=395445 |
t2true, and http://www.cpearson.com/excel/colors.htm Dave t2true Wrote: I have a list of names in a spreadsheet and have color-coded certain ones. Is there a way to sort by the color of the cell or row? Thanks, Ted -- Piranha ------------------------------------------------------------------------ Piranha's Profile: http://www.excelforum.com/member.php...o&userid=20435 View this thread: http://www.excelforum.com/showthread...hreadid=395445 |
All times are GMT +1. The time now is 04:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com