# The Sort by Cell Color Function is Not Working in Excel – 3 Solutions

## Reasons

One of the main reasons is Conditional Formatting. In the image below, the sort cell by color function is not working due to Conditional Formatting.

This is the sample dataset.

### Solution 1 – Applying the Sort Command

To sort values earned by the sales representatives:

Step 1:

• Select  E5:E14.
• In the Data tab, go to

Data → Sort & Filter → Sort

• In the Sort Warning dialog box will, select Expand the selection in What do you want to do?
• Click Sort.

Step 2:

• In the new dialog box (Sort),  select Rev Earned in Sort by.
• Select Cell Color in Sort on.
• Select light golden in Order.
• Choose On Top.
• Click OK.

This is the output.

Read More: [Solved!] Excel Sort Not Working

### Solution 2 – Use the Fill Color Command

Steps:

• Select B4:E14.
• Press Ctrl + T.
• In Create Table, click OK.

A table will be created.

• Click Product.
• In the new window, select  Sort by Color.
• Choose Light Blue.

This is the output.

### Solution 3 – Remove the Conditional Formatting

Steps:

• Select E5:E14.

• In the Home tab, go to

Styles → Conditional Formatting → Clear Rules → Clear Rules from Entire Sheet

This is the output.

Read More: Excel Not Sorting Numbers Correctly

## Related Articles

<< Go Back to Excel Sort Not Working | Sort in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Md. Abdur Rahim Rasel

MD. ABDUR RAHIM is a marine engineer proficient in Excel and passionate about programming with VBA. He views programming as an efficient means to save time while managing data, handling files, and engaging with the internet. His interests extend to Rhino3D, Maxsurf C++, AutoCAD, Deep Neural Networks, and Machine Learning, reflecting his versatile skill set. He earned a B.Sc in Naval Architecture & Marine Engineering from BUET, and now he has become a content developer, creating technical content... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF