sarahbravo
New member
- Joined
- Oct 14, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 0
Hi there, I have set up a spreadsheet showing when our staff completed certain training courses. Some courses are only valid for 1 year, some 3 years, some 5 years etc. I would like to use conditional formatting to highlight if the dates are coming up to expiry (within 4 months of today goes yellow), are very near expiry (within 2 months of today goes orange) or have expired (goes red), and also to ignore if there is no date, as not all courses are relevant to all staff.
Would appreciate any help!
Thanks
Would appreciate any help!
Thanks