Conditional formatting based on another cell

Sarah Duran

I'm trying to turn a cell red if the date there is 2 months past a date in an adjacent cell. Does anyone know how to do this?

Paul Newcome

You would need to insert a helper column and use a formula to populate an indicator when the condition is met. You can then build you conditional formatting to be triggered on this helper column. I would suggest a checkbox with an IF statement and then hide the checkbox column once it has been built out.

Sarah Duran

Thanks!

Paul Newcome

Happy to help. 👍️