conditional formatting
 

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?

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

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

"reno" wrote:

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?

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

"reno" wrote:

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?

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)


"reno" wrote in message
...
seems to have worked, but seems to be off one row, one odd with even and
so
forth. Any workarounds?
Thx

"reno" wrote:

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?