Forum Discussion

Copper Contributor

Jul 12, 2022

Solved

Match Dates and TRUE Value for Conditional Formatting

Hello everyone! 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...

excel

Formulas and Functions

Corder
Jul 21, 2022
Hi all,

Quick update regarding this. I was able to find the solution to what I was looking for:

First I isolated the dates for each color I wanted.

Then used this formula for the conditional formatting and changed the reference column to reflect which dates I wanted highlighted.

I know this was a very niche problem, but in case anyone needs this in the future.

Corder

Copper Contributor

Jul 21, 2022

Hi all,

Quick update regarding this. I was able to find the solution to what I was looking for:

First I isolated the dates for each color I wanted.

Then used this formula for the conditional formatting and changed the reference column to reflect which dates I wanted highlighted.

I know this was a very niche problem, but in case anyone needs this in the future.