how to sort multiple columns in excel by color

The above steps would sort the data where the last chosen color option (green in our example) is at the top of the sorted dataset, followed by the yellow color. Now again, click on the filter icon in any header, hover the cursor on Sort by Color, then on ‘Fill color’, and then click on the “light green 2” color option.This will sort the dataset where all the rows with yellow color are at the top. Click on the “light yellow 2” color option.

In this dataset, I want to sort by color where I have all the green cells at the top followed by the yellow cells and then all the white cells (i.e., the ones that have no color applied to the background).īelow are the steps to sort by multiple colors in Google Sheets: So this is how you can sort by color in Google Sheets when you have one color (apart from the default white).īut what if you have more than one color in the dataset (something as shown below): This will get all the white color cells at the top and all the yellow color cells would automatically be at the bottom. Note: In case you want all the yellow color cells at the bottom, you should sort based on the white color instead of yellow in step 6. The above steps would instantly sort the dataset and give you the result as shown below (where all the yellow color cells are at the top). In this example, I clicked on the “light yellow 2” color Click on the color based on which you want to sort.This will show you all the colors that have been used in the dataset Hover the cursor over the Sort by Color option and then hover it on the Fill color option.Click on the filter icon in any of the column headers (where the column has the color based on which you want to sort).This will apply a filter to the top row in the dataset In the options that show up, click on Create a filter.Select any cell in the data (or select the entire dataset).Suppose you have a dataset as shown below and you want to sort this data based on the color (so that all the cells with yellow color are together at the top).īelow are the steps to sort by cell color in Google Sheets: How to Unsort and Get the Original Data back.

How to sort multiple columns in excel by color