Scribd Logo
Upload

Welcome to Scribd!

  • 50 views

    Shade Alternate Rows in Excel - Easy Excel Tutorial PDF

    Uploaded by

    Jamalodeen Mohammad

    Copyright:

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

    Shade Alternate Rows in Excel - Easy Excel Tutorial PDF

    Uploaded by

    Jamalodeen Mohammad
    50 views5 pages

    Original Title

    Shade Alternate Rows in Excel - Easy Excel Tutorial.pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

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

    Shade Alternate Rows in Excel - Easy Excel Tutorial PDF

    Uploaded by

    Jamalodeen Mohammad

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    of 5

    Shade Alternate Rows in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/shade-alternate-rows.

    html

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

    Shade Alternate Rows


    This example shows you how to use conditional formatting to shade alternate rows. Shading every other row in a
    Chapter
    range makes it easier to read your data.

    1. Select a range. Conditional Formatting

    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:31 PM
    Shade Alternate Rows in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/shade-alternate-rows.html

    shade-alternate-rows.xls

    Follow Excel Easy

    2. On the Home tab, click Conditional Formatting, New Rule...

    3. Click on 'Use a formula to determine which cells to format'.

    2 of 5 08-11 06:31 PM
    Shade Alternate Rows in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/shade-alternate-rows.html

    4. Enter the formula =MOD(ROW(),2)

    5. Select a formatting style and click OK.

    Result.

    3 of 5 08-11 06:31 PM
    Shade Alternate Rows in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/shade-alternate-rows.html

    Explanation: the MOD function gives the remainder of a division. The ROW() function returns the row number. For
    example, for the seventh row, MOD(7,2) equals 1. 7 is divided by 2 (3 times) to give a remainder of 1. For the
    eight row, MOD(8,2) equals 0. 8 is divided by 2 (exactly 4 times) to give a remainder of 0. As a result, all odd rows
    return 1 (TRUE) and will be shaded.

    4 of 5 08-11 06:31 PM
    Shade Alternate Rows in Excel - Easy Excel Tutorial http://www.excel-easy.com/examples/shade-alternate-rows.html

    Colgate Total® Toothpaste


    12hr germ fighting protection and helps prevent
    many oral conditions!

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

    Learn more about conditional formatting, use the side menu >>
    Go to Top: Shade Alternate Rows | 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:31 PM

    You might also like