PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES

Contents

HOW TO SORT DATA BY COLOR IN GOOGLE SHEETS

INTRODUCTION

Sorting is putting up a number of things in a particular fashion as per the selected criteria. Sorting in GOOGLE SHEETS is one of the very basic and frequently used operation.

SORTING IN GOOGLE SHEETS IS THE PROCESS OF ARRANGING THE TEXT OR VALUES SYSTEMATICALLY AS PER THE SELECTED CRITERIA.

For example, suppose there are five kids of different ages and different heights. Now, if we ask them to line up according to their ages, the youngest will be at the first place and the oldest at the last. (If its increasing order and opposite if its decreasing order). But if we want them to be according to height, the order maybe different from the previous case.

 
In this article, we ‘ll specifically discuss about the ways to sort the data using the cell color and text color.
 
The options for SORTING BY COLOR is not given among the sorting group of options in GOOGLE SHEETS. It is given along with the FILTERING OPTIONS.
Let us learn how we can sort data on the basis of colors in GOOGLE SHEETS.

BUTTON LOCATION TO SORT DATA ON THE BASIS OF COLOR GOOGLE SHEETS

The SORT BY COLOR is embedded inside the CREATE FILTER option in GOOGLE SHEETS.

 

The CREATE FILTER BUTTON for SORTING BY COLOR is present under the DATA MENU.

BUTTON LOCATION FOR SORT BY COLOR
BUTTON LOCATION FOR CREATING FILTER TO REACH SORT BY COLOR OPTION

STEPS TO SORT BY COLOR IN GOOGLE SHEETS

Data Sample: LEARNING IS ALWAYS BEST USING THE EXAMPLES.

 

Let us take a simple table containing the name , age, country id.

Out of the given data, a few are colored.

The data is shown in the picture below.

NAMEAGECOUNTRYID
DAVIS23US234
ANABELLE22AUSTRALIA456
DAVID21UK453
RAM19INDIA123
    

STEPS TO DO SIMPLE SORTING BY FILL OR BACKGROUND COLOR IN GOOGLE SHEETS

STEPS:

  • Select the HEADER ROW of the DATA. [You can also click anywhere in the table. The filter will be applied to the header itself, but not a good habit].
  • Go to DATA MENU > CREATE FILTER.
  • It’ll apply a filter to our table which is evident by the small drop down buttons to every header.
 
HOW TO SORT THE DATA BY FILL COLOR IN GOOGLE SHEETS
FILTER APPLIED IN THE GIVEN TABLE IN GOOGLE SHEETS
  • Click The drop down button in the Header Cell of the first column. [ or the column on the basis of which  you want to sort the data ].
  • Choose SORT BY COLOR > FILL COLOR > COLOR BY WHICH WE WANT TO SORT. [ FOR EXAMPLE WE CHOOSE CYAN ]
CHOOSING THE COLOR TO SORT WITH
CHOOSE SORT COLOR>FILL COLOR>CYAN
  • As soon as we click the chosen color, the table will be sorted as per the color chosen and as per the column chosen.
So, we learnt how we can sort the data on the basis of fill color or background color in google sheets.
But a situation can occur when we want to sort the data on the basis of text color.
 
Let us learn how we can sort the data on the basis of TEXT COLOR , that is FONT COLOR.
OUTPUT TABLE
FINAL TABLE [ SORTED BY FILL COLOR TABLE ]

STEPS TO DO SIMPLE SORTING BY TEXT OR FONT COLOR IN GOOGLE SHEETS

STEPS:

  • Select the HEADER ROW of the DATA. [You can also click anywhere in the table. The filter will be applied to the header itself, but not a good habit].
  • Go to DATA MENU > CREATE FILTER.
  • It’ll apply a filter to our table which is evident by the small drop down buttons to every header.
 
FILTER APPLIED IN THE GIVEN TABLE IN GOOGLE SHEETS
  • Click The drop down button in the Header Cell of the first column. [ or the column on the basis of which  you want to sort the data ].
  • Choose SORT BY COLOR >TEXT COLOR > COLOR BY WHICH WE WANT TO SORT. [ FOR EXAMPLE WE CHOSE ORANGE ]
CLICK ON THE SORT BY COLOR > TEXT COLOR > CHOOSE COLOR
CHOOSE SORT COLOR>TEXT COLOR>ORANGE
  • As soon as we click the chosen color, the table will be sorted as per the color chosen and as per the column chosen.
So, we learnt how we can sort the data on the basis of TEXT color or FONT color in google sheets.
 
Let us learn how we can sort the data on the basis of TEXT COLOR , that is FONT COLOR.
FINAL RESULT
FINAL TABLE [ SORTED BY TEXT COLOR TABLE ]

OTHER WAYS TO REACH THIS ARTICLE

  • WHAT IS EXCEL, HOW EXCEL WORKS, WRITE FORMULA IN EXCEL, EXAMPLE OF USING FORMULA IN EXCEL, ANIMATED EXAMLPE OF USING FORMULA IN EXCEL

LEARN

Encourage us by following at …

If you have any queries or suggestions or any problem which you would like us to solve for you, kindly mail at

[email protected]

Share this:

Like this:

Like Loading...

Pin It on Pinterest

Share This

KINDLY SPEND FEW SECONDS HERE....

  • PICTURES ARE TOO SMALL?? Don’t worry, Click them, and pinch zoom to see them properly. All pictures are in high resolution.
  • KINDLY LIKE OUR FACEBOOK PAGE BY CLICKING HERE  AND IF WE NEED TO IMPROVE, KINDLY SEND US THE FEEDBACK ON [email protected]
  • Didn’t get what you were looking for?? Just put your question in the chat box present in the Right Lower corner. Name and email id [No spamming, just for the answer of your requirement] are needed.
*CLICK ANYWHERE ELSE TO CLOSE THIS WINDOW
%d bloggers like this: