How do I use conditional formatting to highlight upcoming dates that do not match?

Chris Patterson

For example, I am using cell linking to pull in two different large pieces of data from two separate sheets. What I'm trying to resolve is how to flag column 3 date if it does not match column 2 date. I want to highlight the dates that don't match so we can resolve as to "why", internally. Thank you for your help with this scenario.

Andrée Starå

Hi @Chris Patterson

You’ll need to add a so-called helper column with a formula that looks at both dates and, for example, checks a box if their not the same. You’d then use that for the conditional formatting rule.

Make sense?

Would that work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!