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.png
    ex1.png
    223.9 KB · Views: 111
Becky

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2 into 1 6
Excel Help with date adding formulas! 7
problem with date in the VBA macro 0
How create a continuous date range: 9/14-9/20/09, 9/21-9/27/09 3
Function Help - Forecast Date past due, adjacent cell is blank. Needto highlight the blank cell. 2
formula to count matching days between two date ranges (for largelist of names) 2
count date ranges 3
Highlight a Date Range 5

Top