Sorting by Cell Color, Font Color or Cell Icon in Microsoft Excel

Excel sorts data according to specific sort order rules. We can sort the number data as per ascending order and descending order. And sort the text according to alphabets A to Z and Z to A. We can sort by font color and cell color in Microsoft Excel.

This option is available in the Data Tab under the Sort & Filter group.

img1

Let’s take an example to understand how we can sort the data by cell color, font color, etc.

We have data in range A1:B14. In data, some cells and fonts contain color. We want to sort data as per font color and cell color.

img2

To sort as per the cell color, follow below given steps:-

  • Select the one cell from data.
  • In the Data tab, select Sort, Sort Options dialog box will appear.
  • Select Revenue ($) in Sort by Column.
  • Select Cell color in Sort on.

img3

  • In order column, select cell color on top.

img4

  • Data will get sorted as per the cell color.

 

Sort as per the font color Follow below given steps:-

  • Select the one cell from data.
  • In the Data tab, select Sort, Sort Options dialog box will appear.
  • Select Revenue ($) in Sort by Column.

img5

  • Select Font color in Sort on.

img6

  • In order column, select font color on bottom.

img7
img8

  • Data will get sorted as per the font color.
  • Custom List dialog box will appear, click the list of agent’s name, Click on ok.
  • Data will get sort as per the custom list.

img9

By following this way, we can sort the data as per fill color and font color.

 

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube