When you selected the rows, was the first row 2?If so, change the formula to
=MOD($A2,2)=1

--

HTH

RP
(remove nothere from the email address if mailing direct)


"reno" wrote in message
...
seems to have worked, but seems to be off one row, one odd with even and
so
forth. Any workarounds?
Thx

"reno" wrote:

have a listing of 200 stores, sorted by store # and date, like to
generate
report where either alternating store numbers are highlighted or all
even
numbers are one color and all odd another...for ease of reading report

each entry has 7 columns, also each store may have from 1 to 7 entiries
now
but will have more in future

e.g., if store # is odd, want to make say blue. Can do the MOD() and
highlight one cell but would like to do the whole row.

any ideas?