|  

» Coloring and Filtering Lists According to Criteria

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



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
Name
Comment Title
Comments