| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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? |
|
#3
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to link website data to Excel cells | Excel Discussion (Misc queries) | |||
| Unable to sort in Excel because of merged cells | Excel Discussion (Misc queries) | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
| Fetching External Data from Excel | Excel Discussion (Misc queries) | |||
| cells lose relativity to other WorkSheets after data sort? | Excel Worksheet Functions | |||
Linear Mode
