Google Exceltip.com
Account Icon
Shopping Cart
CheckOut

» Coloring and Filtering Lists According to Criteria

CATEGORY: Excel Filter
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: 44615
Stupendous
SteveThePirate wrote on December 31, 1969 19:00 EST
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 wrote on December 31, 1969 19:00 EST
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 wrote on December 31, 1969 19:00 EST
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?



REGISTERED USERS click here to post comments


GUESTSclick here to Register
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