conditional formatting

R

reno

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?
 
J

Jason Morin

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
 
R

reno

worked well, except seems to be off one line, an odd in with an even...is
there a workaround? thx
 
R

reno

seems to have worked, but seems to be off one row, one odd with even and so
forth. Any workarounds?
Thx
 
B

Bob Phillips

When you selected the rows, was the first row 2?If so, change the formula to
=MOD($A2,2)=1

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top