Excel Highlight date ranges

[DécioC]

Hey everyone, Im trying to highlight some date ranges on a calendar based on "start date" and "end dates", I was able to do that for the first range using this formula on conditional formatting: =AND(B6>=$BG$5;B6<=$BH$5).
Sadly I can't make it work automaticly for the rest of the date ranges.
Anyone has any idea of how to make it work?

 

[Becky]

What information is contained in cells BG5 and BH5? There's an error in your syntax - the semi-colon should be a comma, but guess that may just be a typo here.