How can I highlight every other group of data?

B

Brandie

I have a spreadsheet with about 4000 lines of data. The lines are grouped by
an unique identifier. One unique identifier has several lines that go with
it. I wanted to use a conditional format to highlight every other group of
data. For example:

1
1
2
2
3
3

Is there a way to highlight both of the 1's and skip the 2's and then
highlight the 3's or is this just a task to do by hand?
 
P

PC

Assuming your identifiers are numeric and each row of the group has the same
identifier

Select the rows you wish to format

Format/Conditional Formatting

Formula is: =MOD($A1,2)=0
then set your format

Replace $A1 with your first row of data and note that the placement of the $
sign is important.

HTH

PC
 
J

Jim Cone

Brandie,

My Excel add-in "Shade Data Rows" does that.
It will shade groups of like valued rows or will shade by every nth row.
Choice of shade colors and an option to skip hidden rows.
Comes with a one page Word.doc install/use file.
It is free upon direct request. Remove XXX from my email address

Regards,
Jim Cone
San Francisco, USA
[email protected]
 
Top