ExcelBanter - Can you sort excel data by color coded cells?

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

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

- - Can you sort excel data by color coded cells? (https://www.excelbanter.com/excel-discussion-misc-queries/38453-can-you-sort-excel-data-color-coded-cells.html)

lbs

Can you sort excel data by color coded cells?

I have a report that has a column coded by color. Is it possible to sort by
color to get each color lumped together?

Bob Phillips

If it is not conditionally formatted colour, see
http://www.xldynamic.com/source/xld....r.html#sorting

--
HTH

Bob Phillips

"lbs" wrote in message
...
I have a report that has a column coded by color. Is it possible to sort
by
color to get each color lumped together?

Chip Pearson

Only with VBA. See http://www.cpearson.com/excel/sortbycolor.htm
for details and examples.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"lbs" wrote in message
...
I have a report that has a column coded by color. Is it
possible to sort by
color to get each color lumped together?

All times are GMT +1. The time now is 11:56 PM.