Toggle Shading Alternate Rows On/Off

[anare]

Hi - I have 2 macros (below) that
1. shades every other row in named range "CF_Range" with conditional formatting "=MOD(ROW(),2)=0"
and inserts with top and bottom borders.
2. the other short macro turns this shading (banding), and top & bottom borders, OFF.

Q1 - can the macro be reduced at all? It was recorded so may contain some superfilous lines.
Q2 - how do I incorporate these into the 1 macro so it toggles shading (banding) between ON and OFF?

Tks

Please Login or Register  to view this content.

[AlphaFrog]

One idea is to have a cell value toggle the stripping.

This example CF formula uses cell A1 as the toggle cell. When A1 = 0, stripping is on. When A1 <> 0, stripping is off.

Please Login or Register  to view this content.

Edit the toggle cell and value to suit.

If you need a macro to toggle the cell's value, try something like this...

Please Login or Register  to view this content.

[anare]

Brilliant! Thanks Alphafrog.