![]() If we used descending, we’d end up with Yes, Other, No, Maybe. If we used an ascending sort, we’d end up with Maybe, No, Other, Yes. Let’s say we tried to sort by the Status column values. When you have a column that contains cell values, but the desired sort order is other than ascending or descending, you can create a custom list. When you have a cell value, we can optionally use a custom list. When you are done, your dialog should look something like this.Īpply the sort and your list should now appear in the desired order, as shown below. ![]() Then click the Add Level button, and repeat using the next color, and so on. Pick the color you want to appear at the top of the list. In the Sort by field, pick any column that includes the colors. This will provide little drop-downs on the header row as shown below.Įxpand any of the drop-downs and select the following: ![]() To sort the list by color, add Sort and Filter controls by selecting any cell in the range and then the following Ribbon command: Sort by Colorįirst, we’ll sort by color, which works on both types of lists. Now, let’s sort both types of lists in a specific order: yes, no, maybe, and other. For example, if the rows are identified by color only, and there is no corresponding cell value, the list may look like this.īut, additionally, there may be a cell value involved with the identification, as illustrated by the Status column below. One is by using a cell value and the other is with cell formatting. How can I sort the list so that all the yes rows are first, then no, then maybe, and then other?” Thanks for your question! Time to get to work. “I have created a color coded list, where yes=green, no=red, maybe=orange, and other is any other color. In this post, I’ll answer a question submitted by reader Chérie about sorting by color. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |