+ Reply to Thread
Results 1 to 3 of 3

Alternating Row Colors Automatically

  1. #1
    Registered User
    Join Date
    11-26-2009
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    12

    Alternating Row Colors Automatically

    I'm using Excel 2007, and wish to make each row alternate between 2 background colors. Is this possible to do automatically or must it be done manually. If automatically is possible, I would be grateful for instructions as I cannot find directions in the Help section of Excel.
    Last edited by stephens; 12-29-2009 at 01:16 AM.

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,372

    Re: Alternating Row Colors Automatically

    Hi stephens,

    you registered only a few weeks ago. Did you have Excel 2003 then and have 2007 now? If so, please update your profile, so you don't have to manually provide the version every time you post.

    In Excel 2007 you can use the Format as Table command on the Home ribbon to choose from several table styles with alternating row colours.

    If you prefer a manual approach, you can apply conditional formatting:

    - select all rows you want to have alternating colors
    - click Conditional formatting on the Home ribbon and choose "new rule"
    - click "use a formula to determine ..." and enter this formula

    =MOD(ROW()/2,1)>0

    - then select a background fill and hit OK.

    hth

  3. #3
    Registered User
    Join Date
    11-26-2009
    Location
    San Diego
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Alternating Row Colors Automatically

    Thanks for your help on this. Much appreciated.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1