Excel - Alternate shading in every other row

[dvirgint]

Hello,

I have a macro which scrapes information from an outside program and creates a table with the information.

To increase readability, I would like to have every other row shaded. Since the amount of information which is scraped varies from time to time, I may have 1 or more pages, and I would like to have the shading only on the section of the table which has data. Is this clear enough?

I have found countless sites with the conditional format formula: =MOD(COLUMN(),2)=0

This is great and works for a fixed number of rows and columns. Can I make this formula dynamic?

Thanks
dvirgint

 

[SkipVought]

hi,

If you have Excel 2007+, use select in the table and use Insert > Table.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[xlbo]

that formula IS dynamic - all that needs to be made dynamic is the range to apply it to

Can you use the macro recorder to record yourself setting that CF over your current data set and then give us an idea of where your data starts from in the sheet?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Actually your posted formula relates to COLUMNS not ROWS.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

What I failed to state is that the TABLE feature in Excel 2007+ has formatting selections for AUTOMATIC alternate row shading and many many other useful features.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}