Conditional formatting two rows at a time

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.

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 wrote:
>
> 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

Perfect, thanks so much Dave.

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" <[email protected]> wrote in message news:[email protected]...
> 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 wrote:
> >
> > 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

You are correct, sir!

David McRitchie wrote:
>
> 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" <[email protected]> wrote in message news:[email protected]...
> > 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 wrote:
> > >
> > > 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

--

Dave Peterson