I am trying to create a calendar. I am trying to use a conditional format to "fill in" the dates where trips are scheduled. I will eventually extend the formatting to include all trip segments, but I am having trouble getting the first one to work. I wrote
="And(CD$3>=$C4,CD$3<=$D4)"
and want it to format the cell with a fill color if true but it isn't working.
I am new to conditional formats so I appreciate the help!
Bookmarks