- Advanced Excel Tutorial
- Advanced Excel - Home
- Excel New Features
- Excel - Chart Recommendations
- Advanced Excel - Format Charts
- Advanced Excel - Chart Design
- Advanced Excel - Richer Data Labels
- Advanced Excel - Leader Lines
- Advanced Excel - New Functions
- Fundamental Data Analysis
- Excel - Instant Data Analysis
- Excel - Sorting Data by Color
- Advanced Excel - Slicers
- Advanced Excel - Flash Fill
- Powerful Data Analysis
- Excel - PivotTable Recommendations
- Powerful Data Analysis – 1
- Advanced Excel - Data Model
- Advanced Excel - Power Pivot
- Excel - External Data Connection
- Advanced Excel - Pivot Table Tools
- Powerful Data Analysis – 2
- Advanced Excel - Power View
- Advanced Excel - Visualizations
- Advanced Excel - Pie Charts
- Advanced Excel - Additional Features
- Advanced Excel - Power View Services
- Advanced Excel - Format Reports
- Advanced Excel - Handling Integers
- Other Features
- Advanced Excel - Templates
- Advanced Excel - Inquire
- Advanced Excel - Workbook Analysis
- Advanced Excel - Manage Passwords
- Advanced Excel - File Formats
- Excel - Discontinued Features
- Advanced Excel Useful Resources
- Advanced Excel - Quick Guide
- Advanced Excel - Useful Resources
- Advanced Excel - Discussion
Advanced Excel - Sorting Data by Color
If you have formatted a table column, manually or conditionally, with the cell color or font color, you can also sort by these colors.
Step 1 − Click on the DATA tab.
Step 2 − Click on Sort in the Sort & Filter group. The Sort dialog box appears.
Step 3 − Under the Column option, in the Sort by box, select the column that you want to sort. For example, click on Exam 2 as shown in the image given below.
Step 4 − Under the topic Sort On, select the type of sort. To sort by cell color, select Cell Color. To sort by font color, select Font Color.
Step 5 − Click on the option Cell Color.
Step 6 − Under Order, click the arrow next to the button. The colors in that column are displayed.
Step 7 − You must define the order that you want for each sort operation because there is no default sort order. To move the cell color to the top or to the left, select On Top for column sorting and On Left for row sorting. To move the cell color to the bottom or to the right, select On Bottom for column sorting and On Right for row sorting.
To Continue Learning Please Login
Login with Google