|
» Applying Colors to Maximum/Minimum Values in a List
CATEGORY: Excel Format |
VERSIONS: All Microsoft Excel Versions |
|
To apply colors to maximum and/or minimum values: 1. Select a cell in the region, and press Ctrl+Shift+* (in Excel 2003, press this or Ctrl+A) to select the Current Region. 2. From the Format menu, select Conditional Formatting. 3. In Condition 1, select Formula Is, and type =MAX($F:$F) =$F1. 4. Click Format, select the Font tab, select a color, and then click OK. 5. In Condition 2, select Formula Is, and type =MIN($F:$F) =$F1. 6. Repeat step 4, select a different color than you selected for Condition 1, and then click OK. Note: Be sure to distinguish between absolute reference and relative reference when entering the formulas. |
| Screenshot // Applying Colors to Maximum/Minimum Values in a List |
  |
|
RATING:
3.36
VIEWS: 28750 |
||||
Sponsors:
 |
Book Store:
Recommended Books:
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Microsoft Windows XP Inside Out
- Good to Great: Why Some Companies Make the Leap... and Others Don't
- Fish! A Remarkable Way to Boost Morale and Improve Results
- The Accounting Game : Basic Accounting Fresh from the Lemonade Stand
- Essentials of Accounting and Post Test Booklet 8, Eighth 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.
