View Single Post
  #1   Report Post  
reno
 
Posts: n/a
Default 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.