Forum Discussion
Sorting Column by colors coded
Hello plask770,
(please note that this solution only works if you have a value of any kind in the cells that are colored)
First make sure you have a filter on the columns you want to sort (by the sound of it you already have done this).
Next you are going to want to select the dropdown arrow on the column you want to sort and select the custom sort option.
After that, you can then add each level of color to have a list of the order you want the color to be sorted in.
That should do it!
Let me know if this answers your question. I understand this might be time consuming if you have a lot of colors, in which case a macro would be better suited for a job like this.
Thanks!
Within my excel I do not have the option to sort by color only sort ascending and descending, text filters, and filter. When I click on text filter I get a custom but it only allows me to sort by items like equal, is greater than etc. There is not an option for color.
Try clicking on the "Data" tab of the ribbon and select the "Sort" option to the left of the "Filter" button. If that doesn't work, can you let me know what version of Excel you are running?
that does not work either. So I am using the Office 365 version.
Would you be able to send a screenshot of what you see? I am also using Office 365.