Conditional formatting
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.
|