reno,

Select your rows, then use Format | Conditional Formatting... Select
"Formula Is.." and use the formula

=$A1/2=INT($A1/2)

Change A1 to reflect the column with your store#, and the row with your
first store. Then set the format.

HTH,
Bernie
MS Excel MVP

"reno" wrote in message
...
have a set of 200 stores, each w/unique store# and 7 add'l columns of
info,
each store might have 1 to 10 entries. Entries are sorted by store # and
date

Would like to cond format such that all even number store rows are one
color
and all odd are another color or whie by default. Tried several
approaches
w/o success. Prefer cond formatting rather than going row by row
manually.