Results 1 to 4 of 4

Possible to Alternate Colors of Multiple Rows of Categories

Threaded View

  1. #1
    Registered User
    Join Date
    10-31-2013
    Location
    Whoville
    MS-Off Ver
    Excel 2010
    Posts
    2

    Possible to Alternate Colors of Multiple Rows of Categories

    I have looked online for help in this regard, but it seems like most people want alternating colors for every other row. I would like alternating colors for multiple rows of same category material.

    It's for a law firm, so I can't use real figures, so I'll make it about baseball and it's basically something like this:

    Team | Unique Team Number | Player

    New York Yankees | 33 | Babe Ruth
    New York Yankees | 33 | Mickey Mantle
    New York Yankees | 33 | Derek Jeter
    Baltimore Orioles | 34 | Cal Ripken, Jr.
    Balitmore Orioles | 34 | Eddie Murray
    Chicago Cubs | 35 | Ryne Sandberg
    Chicago Cubs | 35 | Sammy Sosa

    So basically I would like the Yankees to be default white and all the Orioles to be some other color, like light gray, and then the Cubs are back to default white, and so on. It could be done manually in a baseball sense, of course, but I'm dealing with thousands of matters. They do all have unique numbers, so is there a way to pivot off of that in the style options?

    Thanks very much and Happy Halloween!
    Last edited by syuzhet; 11-01-2013 at 10:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. alternate Formatting on multiple rows
    By bimo in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 06-21-2013, 10:08 AM
  2. Select multiple alternate rows
    By napspsc in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 08-30-2011, 12:35 PM
  3. Alternate row colors
    By speakers_86 in forum Excel General
    Replies: 2
    Last Post: 06-25-2007, 12:37 AM
  4. Alternate Background-colors
    By sissi in forum Excel General
    Replies: 1
    Last Post: 08-21-2006, 11:16 AM
  5. [SOLVED] Alternate Colors
    By Mark G. in forum Excel General
    Replies: 2
    Last Post: 12-11-2005, 08:10 AM

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