View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gmac gmac is offline
external usenet poster
 
Posts: 2
Default Is there a way to do this?

Hi everyone!

Okay so I have a spreadsheet for project scheduling set up with the month
name April - March in cells G4 - R4 . In cell C6 I have a start date of
04/01/07 and in cell D6 I have an end date of 07/01/07 for example. What I am
wanting to do is have each cell under each month turn "Blue" to show the time
frame of that project. Can this be done? Would I have to enter a formula for
each cell April - March? Any help would be great. Thanks!