I have a yearly calendar that updates automatically when the start date is changed. This is what the calendar looks like:
In a separate sheet, I have all of the dates from the calendar with a formula that writes TRUE if the date is in increments of two weeks from a start date. I have conditional formatting set on the dates to change the color when a given column = TRUE.
I am trying to have a similar conditional formatting on the calendar itself to match the REF column's color. Any assistance would be greatly appreciated! Let me know if anymore information is needed.