Lesson 3: Sorting a range on colour

Welcome back to this, a continuation from the lesson “Sorting a range on multiple columns“.

Sorting data by colour is a great way to make data analysis easier and help the users of your worksheet see the highlights and data trends at a quick glance.

Overview

Sorting data is an integral part of data analysis. You sort data to quickly organize your data and to find the data that you want. Sorting data can help you and other people who use your spreadsheet make more effective decisions based on your data. You can sort data by format, including cell color and font color, whether you have manually or conditionally formatted the cells.

Exercise

To sort data by colour, execute the following steps:

  • Download and extract the contents of the zip archive Sorting by Colour.
  • Open the file “Sorting by Colour.xlsx”
  • Click any single cell inside the data set.

  • On the Data tab, click Sort.

The Sort dialog box appears.

  • Sort by First Name (or any other column), sort on Cell Colour (you can also sort on Font Color and Cell Icon), and select the green colour for the first level.

  • Click ‘Copy Level’ two times and select the other colours.
  • Click OK

Result.

In our next lesson, we shall look at: REVERSING AN EXCEL LIST.

Thanks for the custom.

Share this

Latest

Most Recent Insights

Most Popular Insights

DOWNLOADABLE RESOURCES

Categories

Related Articles

What is your scale?

I am called Mustapha B. Mugisa, your success partner. I want you to know that life is about making choices of the things you

The state of banking 2022: What you should expect in the summitBI Bank Report 2022

The COVID-19 pandemic created enormous headwinds for the economy as well as the financial services sector. It became clear that banks needed to respond

Ethics and integrity training – the new focus for well managed organizations

Lack of ethics and integrity is the cause of all problems. As we speak now, someone in an organization is stealing from it. ACFE.com

Why you need a ‘strategic website’ NOT just any other site?

How do you manage online growth? Plan for the future? Stay competitive? You need advice that understands your needs. Having a robust website is

About Author