Turn Date Red

srivers71

I am looking to turn the date red if past due + 7 days. Conditional formatting is not working. Does anyone have the formula to make this work? See screenshot below

Marvin Daniels

Hello @srivers71

I would create a helper column (that can be hidden) to determine overdue days, something like:

=NETWORKDAY([Finish]@row, TODAY())

Then use this column to drive conditional formatting and notifications/update requests.