Conditional formatting two rows at a time
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" wrote in message ...
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
|