conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
worked well, except seems to be off one line, an odd in with an even...is
there a workaround? thx
 
seems to have worked, but seems to be off one row, one odd with even and so
forth. Any workarounds?
Thx
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting 6
combining data from multiple worksheets into one 6
Conditional Formatting using Small 1
conditional formatting 1
Conditional Formatting 2
Refering back to a spreadsheet saved on the internet 1
Conditional Format Font Color for more than 3 conditions 3
Conditional Highlight 16

Back
Top