How to Use Excel Conditional Format Results to Sort and Filter


excel-logo

Suppose you had values in Column A of your worksheet and a list in Column B. There is a conditional format that makes any value in Column A turn red if it is also in Column B and you want to sort or filter by that result and it is not terribly difficult to do.

All you have to do is set up your data and your conditional formats to your liking.

Follow the steps below to learn how to set up your sorting:

  1. Select all the cells you would like included in the sort
  2. Display the Data tab of your Ribbon
  3. Click the Sort tool to open the dialog box

microsoft-excel-sort

  1. Using the Sort By drop-down list, select Column A, where your conditional formatting has been applied
  2. Using the Sort On drop-down list, select Font Color
  3. Using the Order drop-down list under Order, select the color you would like to sort by. In this instance it would be red
  4. Using the second drop-down list under Order, specify whether you want the red font cells to be on top or on the bottom of the list
  5. Click OK

That’s all there is to it. If the colors of your cells change because of conditional formatting, you can resort your table and you will have no problems.

Should you want to filter by the colors you can easily do that using an AutoFilter.

Follow the steps below to learn how:


  • Turn on AutoFiltering by clicking on the Data tab of your Ribbon
  • In the Sort and Filter group, select Filter
  • Click the down-arrow at the top of Column A and you will see many options available to you
  • Select Filter by Color to display a list of the colors that are in your column
  • Select the color that you would like displayed. Usually one would select Automatic

About the Author

Carol Bratt

Carol holds A+, MCP, and MOS computer certifications and is the resident DCT Office expert. She trains the staffs of small law firms in the use of Microsoft Office applications and has authored many books covering Microsoft Office as well as written articles for Infopackets, TechnoLawyer, and Digital Harbor. For more Microsoft Office tips visit Carol's Corner Office or follow Carol on FaceBook and Twitter.

There are no comments

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