EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS

[LOTLITA64]

I HAVE AN EXCEL SPREADSHEET THAT HAS SHADED ROWS. EVERY OTHER ROW IS SHADED
GREY. IS THERE A WAY TO FORMAT A WORKSHEET SO THAT WHEN A ROW IS ADDED, IT
AUTOMATICALLY HAS THE EVERY OTHER ROW SHADING FORMAT SO THAT YOU DO NOT HAVE
TO GO BACK A RE-SHADE EVERY OTHER ROW GREY?

 

[Teethless mama]

Use format painter icon and copy down as far as needed

 

[Gord Dibben]

Please drop the all caps.........hard to read and even harder on the ears.

Select a bunch of rows then............

Format>Conditional Formatting>Formula is: enter the following.

=MOD(SUBTOTAL(3,$A1:$A$2),2)=0 Format to a nice color.

This will retain the row formatting throughout sorting or filtering.


Gord Dibben MS Excel MVP

 

[Gord Dibben]

And will retain the banding when inserting or deleting rows.


Gord