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?