+ Reply to Thread
Results 1 to 4 of 4

How do I color rows alternately? Not 1 row after the other, but depending on column data

  1. #1
    Registered User
    Join Date
    10-14-2012
    Location
    Planet Earth
    MS-Off Ver
    Excel 2010
    Posts
    6

    How do I color rows alternately? Not 1 row after the other, but depending on column data

    I have some sales data with orders and item details listed in a excel worksheet. The order # is listed in column A, and the items for that order are listed in column B. A single order can contain many items I want all rows in one order to be colored the same, and the next order to be colored differently so that I can see the difference immediately. I've attached an excel sheet to show what I mean! Any help would be appreciated. Thanks!
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: How do I color rows alternately? Not 1 row after the other, but depending on column da

    Select your range

    Conditional format


    Color 1:

    =MOD($A2,2)=0


    Color 2:

    =MOD($A2,2)=1

  3. #3
    Registered User
    Join Date
    10-14-2012
    Location
    Planet Earth
    MS-Off Ver
    Excel 2010
    Posts
    6

    Re: How do I color rows alternately? Not 1 row after the other, but depending on column da

    Thank you!
    Attached Files Attached Files
    Last edited by Cutter; 10-27-2012 at 05:18 PM. Reason: Removed whole post quote

  4. #4
    Banned User!
    Join Date
    10-14-2006
    Posts
    1,211

    Re: How do I color rows alternately? Not 1 row after the other, but depending on column da

    You're welcome!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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