|  

» Coloring and Filtering Lists According to Criteria

CATEGORY - Excel Filter VERSION - All Microsoft Excel Versions
To color filtering results according to criteria:
1. Filter the List.
2. Press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the Current Region.
3. From the Formatting toolbar, select Fill Color, and choose a color.
4. Repeat the steps above, choosing new criteria and different colors.

Screenshot // Coloring and Filtering Lists According to Criteria
Coloring and Filtering Lists According to CriteriaColoring and Filtering Lists According to CriteriaColoring and Filtering Lists According to Criteria



Book Store:

VIEW ALL BOOKS

Recommended Books:

Print Tip
Add to My Tips
Rate This Tip
12 34 5
Rating: 2.81     Views: 46109
Stupendous
SteveThePirate
I use this all the time, and if I didn't look under here I would have never been able to. So thank you very much.
Stupendous
SteveThePirate
I use this all the time, and if I didn't look under here I would have never been able to. So thank you very much.
Filter the colour
powercarol
What about filter the cells filled with a colour? There is not common pattern in the cells except they are all highlighted by the same colour?
Click here to post comment
For Registered Users
Click here to Regiser
For Guest
Name
Comment Title
Comments


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.

Copyright © 2003 ExcelTip.com Microsoft, Microsoft Excel is a U.S. registered trademark of Microsoft Corporation