View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
LOTLITA64 LOTLITA64 is offline
external usenet poster
 
Posts: 2
Default 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?