Conditional formatting two rows at a time

[Mike K]

Given a data set of the following:

City, Some number
Atlanta, 4
Altanta, 7
Dallas, 3
Dallas, 1
Toronto, 8
Toronto, 10
Trenton, 12
Trenton, 1

Can I do conditional formatting so that each set of two rows has
alternating colors? For example, the two rows with Atlanta are
highlighted yellow, Dallas white, Toronto yellow, Trenton white.

 

[Dave Peterson]

Maybe use format|conditional formatting.

Select your range A2:Bxxx (headers in row 1??)

Then with A2 the activecell
format|conditional formatting
formula is:
=MOD(ROW(A2),4)<2
And give it a nice yellow pattern.

 

[Mike K]

Perfect, thanks so much Dave.

 

[David McRitchie]

If A2 is the active cell for
=MOD(ROW(A2),4)<2
you could simply code as
=MOD(ROW(),4)<2
for exactly the same meaning and effect.

 

[Dave Peterson]

You are correct, sir!

If A2 is the active cell for
=MOD(ROW(A2),4)<2
you could simply code as
=MOD(ROW(),4)<2
for exactly the same meaning and effect.