EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
 

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?

EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
 

Use format painter icon and copy down as far as needed


"LOTLITA64" wrote:

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?

EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
 

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

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

FormatConditional FormattingFormula 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

On Fri, 25 Jan 2008 10:53:07 -0800, LOTLITA64
wrote:

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?

EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS
 

And will retain the banding when inserting or deleting rows.


Gord

On Fri, 25 Jan 2008 11:40:14 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

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

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

FormatConditional FormattingFormula 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

On Fri, 25 Jan 2008 10:53:07 -0800, LOTLITA64
wrote:

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?