is therer a way to group or sort so all my cells that have a blue color will go to the top?
P Pammy Jan 17, 2008 #1 is therer a way to group or sort so all my cells that have a blue color will go to the top?
N Niek Otten Jan 17, 2008 #2 Look here: http://xldynamic.com/source/xld.ColourCounter.html -- Kind regards, Niek Otten Microsoft MVP - Excel | is therer a way to group or sort so all my cells that have a blue color will | go to the top?
Look here: http://xldynamic.com/source/xld.ColourCounter.html -- Kind regards, Niek Otten Microsoft MVP - Excel | is therer a way to group or sort so all my cells that have a blue color will | go to the top?
C Chip Pearson Jan 17, 2008 #3 You need VBA code to do this. See http://www.cpearson.com/Excel/SortByColor.htm -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site)
You need VBA code to do this. See http://www.cpearson.com/Excel/SortByColor.htm -- Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2008 Pearson Software Consulting, LLC www.cpearson.com (email on web site)
