Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? . |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Losing conditional formatting when saving | Excel Discussion (Misc queries) | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |