ExcelBanter - sort by color

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - sort by color (https://www.excelbanter.com/excel-discussion-misc-queries/173502-sort-color.html)

Pammy

sort by color

is therer a way to group or sort so all my cells that have a blue color will
go to the top?

Niek Otten

sort by color

Look he

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Pammy" wrote in message ...
| is therer a way to group or sort so all my cells that have a blue color will
| go to the top?

Chip Pearson

sort by color

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)

"Pammy" wrote in message
...
is therer a way to group or sort so all my cells that have a blue color
will
go to the top?

Tyro[_2_]

sort by color

You can sort by color in Excel 2007. See the ribbon.

Tyro

"Pammy" wrote in message
...
is therer a way to group or sort so all my cells that have a blue color
will
go to the top?

All times are GMT +1. The time now is 08:33 PM.