Results 1 to 10 of 10

Excel 2007 : Highlight every other group of rows

Threaded View

  1. #1
    Forum Contributor
    Join Date
    11-17-2004
    MS-Off Ver
    Office 2016
    Posts
    527

    Highlight every other group of rows

    I’m trying to take a table of duplicate information and highlight every other row with a light grey highlight just so it’s easier to see the individual groups. The duplicate data is sorted and in column A and the other columns will have varying bits of data. sometimes there are 2 duplicate values and sometimes there are 3, maybe even 4.

    In the example below, the rows with 12345 data should be light gray along with the 98765 rows

    12345	data1	data2	data3
    12345	data3	data2	data1
    54321	data1	data2	data3
    54321	data4	data5	data6
    54321	data7	data6	data5
    98765	data1	data5	data2
    98765	data3	data1	data8
    Last edited by JimDandy; 01-20-2010 at 03:04 PM.

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