Forum Discussion

Lennox2525's avatar
Lennox2525
Copper Contributor
Jan 31, 2023

Conditional Formatting using dates

Hi, 

 

Can anyone help me?

 

Using one column on a spreadsheet and conditional formatting I need to do the following for test certificates that are due/expired/no action required as below.

 

Green for anything within date & right up to the expiry date (day before).

Orange for expiry due date + 2 weeks

Red for once expiry has gone overdue (past 2 weeks from orange flag) until test has been taken & then reverts back to green.  

Resources