Excel Highlight date ranges

D

DécioC

Joined
Oct 13, 2016
Messages
7
Reaction score
1
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?
 

Attachments

  • ex1.webp
    ex1.webp
    87.7 KB · Views: 118
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.
 
Back
Top