Automate color change on a Date-category cell

In attached scenario, is there a formula that will enable “Target Date” cell turns to red color when it is smaller/earlier than “Completion Date”?

Inserting a Date category column and setting up conditional formatting gets the job done. I'm curious whether there is a simplier way.

Thank you.

Jon

Query - Show Date under IF constraint.png

Find more posts tagged with

Formulas

Comments

Heidi Decker

Good Morning Yagu,

For this you should add another column that will run a formula that will calculate the difference between the 2 date columns. Then set a conditional format using that result to turn your Target Date cell red.

Jonathan Chan

Morning Heidi:

Thanks for the confirmation. This is the method I performed, and was curious whether there is a simpler method.

Good day.