|
» Coloring and Filtering Lists According to Criteria
CATEGORY: Excel Filter |
VERSIONS: 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 |
    |
|
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?
Sponsors:
 |
Book Store:
Recommended Books:
- Now, Discover Your Strengths
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Microsoft PowerPoint Version 2002 Step by Step
- Accounting and Financial Fundamentals for Nonfinancial Executives
- F1 Get the Most out of Excel! The Ultimate Excel tip Help Guide
- Financial Statement Analysis: A Practitioner's Guide, 3rd Edition
Related MS EXCEL TIPS:
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.
