1. Select the rows.
2. Go to Format Conditional Formatting
3. Select "Formula Is" on the drop-down.
4. Enter:
=MOD($A1,2)=1
5. Press the format button and format as desired.
This assumes store number is in col A.
HTH
Jason
Atlanta, GA
-----Original Message-----
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?
.
|