I need a formula that will turn the date in the Contacted Date column grey, if it is more than one d

skh

I need a formula that will turn the date in the Contacted Date column grey, if it is more than one day past the date in the Assigned column.

And I need a formula that will turn the date in the Planned Inspection column grey, if it is more than two days past the date in the Assigned column.

Mark.poole

@skh

in your attempted contact helper column

=IF([Attempted Contact]@row > Assigned@row+1,1,0)

use conditional formatting to turn Attempted Contact column grey if flagged.

in contacted date helper

=IF([Planned Inspection]@row > Assigned@row+2,1,0)

with conditional formating

skh

Thank you, Thank you!!!