![How to sort data by color in excel for mac 2016](https://kumkoniak.com/98.jpg)
From the Sort dialog box, firstly, select Rev Earned from the Sort by drop-down box.
- Further, a new dialog box named Sort pops up.
- From the Sort Warning dialog box, firstly, select Expand the selection from the What do you want to do? Secondly, press the Sort option.
Hence, the Sort Warning dialog box will appear in front of you.First of all, select the cells array E5 to E14.Let’s follow the instructions below to fix this problem! From our dataset, we will sort the revenue earned by the sales representatives with the cell light golden color. This is the easiest and the most time-saving way. In this method, we will apply the Sort Command to fix the sort by cell color not working error in Excel. Apply Sort Command with Proper Steps to Solve the Issue in Excel Here’s an overview of the dataset for today’s task.ġ. To fix the error, we will apply the Sort Command, Conditional Formatting, and Fill Color Command. From our dataset, we will solve the sort by cell color not working error. The Name of the sales representatives, their Identification Number, type of products, and the revenue earned by the sales representatives are given in columns B, C, D, and E respectively. Let’s say, we have a dataset that contains information about several sales representatives of the Armani group. Due to Conditional Formatting, the sort y cell color not working error occurs which has been given in the below screenshot.ģ Suitable Ways to Fix Sort by Cell Color Not Working in Excel Take this for an example given below in the picture.
If your cells are pre-formatted by the conditional formatting feature then you might face this problem. One of the main reasons is the Conditional Formatting Feature.
There are several reasons behind the sort by color does not work in Excel. Reasons Behind Sort by Cell Color Not Working in Excel