Match Dates and TRUE Value for Conditional Formatting

Question

Hello everyone!&nbsp;I have a yearly calendar that updates automatically when the start date is changed. This is what the calendar looks like:&nbsp;&nbsp;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.&nbsp;&nbsp;&nbsp;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.

corder · Accepted Answer

Hi all,&nbsp;Quick update regarding this. I was able to find the solution to what I was looking for:&nbsp;First I isolated the dates for each color I wanted.&nbsp;&nbsp;Then used this formula for the conditional formatting and changed the reference column to reflect which dates I wanted highlighted.&nbsp;&nbsp;I know this was a very niche problem, but in case anyone needs this in the future.&nbsp;

Forum Discussion

Match Dates and TRUE Value for Conditional Formatting

Share

Resources