View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jeff jeff is offline
external usenet poster
 
Posts: 4
Default Alternating Changing Color of Cells (a Range) across a Spreadsheet

Hi again

I want to be able to change the color of a range of cells across a
spreadsheet alternating the colors ie

Range(A1,H1) - Pale Blue then Range(I1,N1) Pale yellow then Range(O1,S1)
Pale Blue and so on....

Any advice on this simple idea? I was hoping to be able to do something like
Range(A1,H1).BackColor = RGB(192, 255, 255)
but I think that was wishfull thinking...

cheers
Jeff