Automate color change on a Date-category cell

Jonathan Chan

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

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.