قالب وردپرس درنا توس
Home / Tips and Tricks / Can Excel sort by color? To fill in the color and use the custom sorting of Sort & Filter

Can Excel sort by color? To fill in the color and use the custom sorting of Sort & Filter



Can I sort Excel by color? Absolute. Excel can not only sort by values, but also by cell color, font color, and cell icon.

First, you must define the colors for your sort columns / fields. In this example, we select colors based on the column SALES.

. 1 Mark all lines with a turnover of 100 to 500 million. To select a background color, click Home in the main menu bar and go to the Font group. Find the paint bucket icon that represents Fill Color and click the down arrow next to it. A color palette is displayed from which you can select a color by clicking on the thumbnail. For our example, we have selected yellow from the group Standard Colors.

. 2 Highlight the next group with sales of 77-85 million, then select Blue.

. 3 Choose between 60 and 65 million green. for 50 million choose Orange; Choose lavender for 40 to 45 million and cyan (turquoise) from 30 to 39 million.

  01 Select colors for each specific area JD Sartain / IDG Worldwide

Select colors for each specific area

Now The colors are defined by SALE, you can use them to post to BOOK , AUTHOR, LANGUAGE or PUB DATE and, for example, to display authors with a turnover of cyan, which denotes the group with a conversion between 30 and 39 million. [19659002] 1. Move the cursor anywhere within the data range and press Ctrl + A to highlight everything.

. 2 On the Home tab, in the main menu, select the group Edit . Click Sorting and Filtering> Custom Sorting . The Sort dialog box opens.

. 3 If you have headers, check the box . My data has headers .

. 4 Select a sort key from the Sort By field under Column such as Author .

. 5 Under Sort On select Cell Color from the drop-down list.

. 6 Under Order select the thumbnail for the color you want to sort by – in our example, it's cyan.


Source link