Conditional Formatting for deadlines

[Mduncan88]

Hello all,
I am looking for a visual color scheme to inform me of when my deadlines are coming up/past.
I would like my deadline column to turn either red, yellow or green.
Red for past the deadline from the current date.
Yellow for on the deadline or 7 days prior to from the current date.
Green for more than 7 days from the deadline.
I have tried vigorously to get the yellow to work but there is something I am missing.
Please see the attached excel document.
Best Regards,

Work_Order_Log.xlsx

[dilipandey]

Hi Mduncan88,

Welcome to the forum.
Please see the attached file where I have applied the required conditional formatting logics. thanks.


Work_Order_Log.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>