Mel Smith
Well-known Member
- Joined
- Dec 13, 2005
- Messages
- 1,023
- Office Version
- 365
- Platform
- Windows
I have a large spreadsheet, formatted as a table. column J shows an expected delivery date. I would like to add in column M some conditional formatting to show:
Overdue (i.e not received by today)
Delivery expected (i.e. due today and/or within 3 days)
On time (i.e. due in four days +)
Could someone point me in the right direction, please? Should i use an IF statement or IFS?
Many thanks,
Mel
Overdue (i.e not received by today)
Delivery expected (i.e. due today and/or within 3 days)
On time (i.e. due in four days +)
Could someone point me in the right direction, please? Should i use an IF statement or IFS?
Many thanks,
Mel