Hello,

I set up an excel sheet to have dates running in row 1. Example: K1 =
1/1/07, L1 = 1/15/07, M1 = 1/29/07, N1 = 2/12/07, you notice the dates run
every 2 week intervals. This goes all the way to BP1 = 3/9/09.

Cell H2 = start date
Cell I2 = end date

Now, I need to set a formula where if user enters start date and end date in
H2 and I2 then cells K2 - BP2 will highlight "yellow" accordingly. This is
to make easy visually to track and manage projects.

Also, I need to have 2 more conditional formulas to highlight cells.

1) This formula will take the start date and calculate backwards 45 days to
highlight pre-work (green)
2) This formula will take the end date and tack on 14 days for post work and
highlight these cells red.

Can this be done? Thanks for looking.
--
Thank You!