How to sort by color in excel mac

That there are no blanks in the range. That, after the sort, the data records are intact and correct. The following steps show how to sort the data by cell background color: Highlight the range of cells to be sorted in the example, cells A2 to D The four records with the red cell color are grouped together at the top of the data range. In the image, for the range of cells A2 to D11, conditional formatting was used to change the font color of student records based on their programs of study: Red font: Here's how to sort the data by font color: Select Home.

Select Custom Sort in the drop-down list to open the Sort dialog box. Under the Sort On heading in the dialog box, choose Font Color from the drop-down list. When Excel finds different font colors in the selected data, it adds those colors to the options listed under the Order heading in the dialog box. Under the Order heading, select the color red from the drop-down list.

Filter by font color, cell color, or icon sets - Excel for Mac

If necessary, chose On Top under the sort order so that the red-colored data will be at the top of the list. At the top of the dialog box, select Add Level to add the second sort level. For the second level, under the Order heading, select the color blue from the drop-down list. Chose On Top under the sort order so that the blue-colored data will be above those records with the default black font. Select OK to sort the data and close the dialog box.

The two records with the red font color are grouped together at the top of the data range, followed by the two blue records. If your cells are colored with many different colors, it is not necessary to create a formatting rule for each and every one of them. You can create rules only for those colors that really matter for you, e. September 25, at Svetlana Cheusheva says: Nick says: October 2, at 9: For example I have a budget with a pull down list as follows "Paid" "Quoted" "Deposit" etc When the cell is Paid conditional formatting is set to fill grey the entire cell row.

October 3, at Kasun says: August 5, at 7: Hi Nick, Hope this might helpful for your request.


  1. sony reader prs-t1 mac os?
  2. ping test on mac 10.8?
  3. Filter a list of data!
  4. copy down in excel mac.
  5. best mac eyeshadows for brown eyes and fair skin;

Let me know if you need help on this. Thank you. Marco J. October 23, at This was incredibly useful.

Good job putting these intructions together. Anonymous says: November 21, at Ankur Verma says: March 5, at 4: DAVE says: April 13, at 9: Maria Azbel Ablebits.

3 Ways to Sort by Color in Excel

February 18, at Hello, Dave, To help you better, we need a sample table with your data in Excel. June 23, at 6: Hello, Habeeb, To help you better, we need a sample table with your data in Excel. Ross says: October 8, at Hello, Ross, To help you better, we need a sample table with your data in Excel. Josh says: October 21, at 3: Hello, Josh, To help you better, we need a sample table with your data in Excel. John says: March 1, at 1: WHen i enter the Getcellcolor formula it does not work.

March 18, at Hello, John, Please have a look at this article How to count and sum cells by color.

Was this information helpful?

Kaveh says: March 12, at 1: Hello, Kaveh, Please have a look at this article How to count and sum cells by color. Dibin says: April 20, at 7: How to filler a particular data based on their color in a work book,. Dustin says: May 11, at 2: Antony Thomas Maliakal says: June 3, at 1: August 31, at 8: September 11, at 3: Carrie says: January 30, at 5: August 16, at 8: I appreciate the effort put into explaining the features present in Excel.

Kevin says: December 15, at 7: Gennady Terekhov Ablebits. February 28, at 1: Hi Kevin, Please check that there are cells with more than one font or fill color in the selected column. Kevin Williams says: January 16, at 4: Hello, Perhaps, there are no cells with another font color except Automatic in the column you select for sorting.

Alternating Row and Column Colors and Other Formatting Options in Excel

Sharon R Checkosky says: This works just as well for Font Color. So now all of that cell and font coloring you've done can be really useful. You must be logged in to post a comment. To do this, simply click the Text Highlight button on the ribbon and select your color: