Scribd Logo
Upload

Welcome to Scribd!

  • 96 views

    Excel Color Scales - Easy Excel Tutorial

    Uploaded by

    Jamalodeen Mohammad
    Excel Color Scales

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    Excel Color Scales - Easy Excel Tutorial

    Uploaded by

    Jamalodeen Mohammad
    96 views5 pages
    Excel Color Scales

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Excel Color Scales

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    96 views5 pages

    Excel Color Scales - Easy Excel Tutorial

    Uploaded by

    Jamalodeen Mohammad
    Excel Color Scales

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 5

    Excel Color Scales - Easy Excel Tutorial http://www.excel-easy.com/examples/color-scales.

    html

    Excel Easy
    #1 Excel tutorial on the net Excel Introduction Basics Functions Data Analysis VBA 300 Examples Ask us

    Color Scales
    Color Scales in Excel 2010 make it very easy to visualize values in a range of cells. The shade of the color
    Chapter
    represents the value in the cell.

    To add a color scale, execute the following steps. Conditional Formatting

    1. Select a range.

    2. On the Home tab, click Conditional Formatting, Color Scales, and click a subtype. Learn more, it's easy

    Manage Rules

    Data Bars

    Color Scales

    Icon Sets

    New Rule

    Find Duplicates

    Shade Alternate Rows

    Compare Two Lists

    Conflicting Rules

    Checklist

    Download Excel File

    1 of 5 08-11 06:29 PM
    Excel Color Scales - Easy Excel Tutorial http://www.excel-easy.com/examples/color-scales.html

    color-scales.xlsx

    Follow Excel Easy

    Result:

    Explanation: by default, for 3-Color scales, Excel calculates the 50th percentile (also known as median, middle
    value or midpoint). The cell that holds the minimum value (9) is colored red. The cell that holds the median (36) is
    colored yellow, and the cell that holds the maximum value (80) is colored green. All other cells are colored
    proportionally.

    Read on to further customize this color scale.

    3. Select the range A1:A7.

    4. On the Home tab, click Conditional Formatting, Manage Rules.

    2 of 5 08-11 06:29 PM
    Excel Color Scales - Easy Excel Tutorial http://www.excel-easy.com/examples/color-scales.html

    5. Click Edit rule.

    Excel launches the Edit Formatting Rule dialog box. Here you can further customize your color scale (Format
    Style, Minimum, Midpoint and Maximum, Color, etc).

    Note: to directly launch this dialog box for new rules, at step 2, click More Rules.

    6. Select 2-Color Scale from the Format Style drop-down list and select white and blue.

    7. Click OK twice.

    3 of 5 08-11 06:29 PM
    Excel Color Scales - Easy Excel Tutorial http://www.excel-easy.com/examples/color-scales.html

    Result.

    4 of 5 08-11 06:29 PM
    Excel Color Scales - Easy Excel Tutorial http://www.excel-easy.com/examples/color-scales.html

    Do you like this free website? Please follow us on Google+

    Learn more about conditional formatting, use the side menu >>
    Go to Top: Color Scales | Go to Next Chapter: Charts

    COPYRIGHT (C) 2010-2015 WWW.EXCEL-EASY.COM. ALL RIGHTS RESERVED.


    EXCEL 2010 TUTORIAL | HOW TO EXCEL | MICROSOFT EXCEL 2010 | EXCEL MACRO

    5 of 5 08-11 06:29 PM

    You might also like