Conditional Formatting - Start / End Dates, Shade a block of cells

[pdvsa]

Hello Excel Gurus,

I am looking for a formula much like the following to shade a block of cells based on start and end dates.
=AND($B8:J8>=$B2,$B8:J8<=$B3)
that formula doesnt work though as I do not know how to properly use a range of dates.

grateful for your help. Let me know if you have any questions.

 

[Fluff]

Duplicate to: Conditional Format between dates

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.