yewkey
New Member
- Joined
- Jan 12, 2023
- Messages
- 16
- Office Version
- 365
- 2019
- 2010
- Platform
- Windows
- Mobile
Hi All,
Happy New Year to all, hoping you're all well.
I am trying to create a training spreadsheet that will track training and highlight the cells with green, Amber and red accordingly when training is in date, close to expiry and expired.
The training needs to be renewed on a 6 monthly basis.
Example: if training was done today upto and including 5 months from today the cell would remain green.
From the 5th month until 1 day before expiry should turn Amber and then on the day of the 6th month be red.
Once training has been completed and the new date input should turn green again and repeat.
I hope this makes sense, I'm sure it's probably quite basic but all of my excel training has been self taught from youtube/Google so please be kind.
I'm thinking it's something with using =today but can't quite figure it out, I'm hoping your expertise will be able to help me.
Many Thanks All
Yewkey
Happy New Year to all, hoping you're all well.
I am trying to create a training spreadsheet that will track training and highlight the cells with green, Amber and red accordingly when training is in date, close to expiry and expired.
The training needs to be renewed on a 6 monthly basis.
Example: if training was done today upto and including 5 months from today the cell would remain green.
From the 5th month until 1 day before expiry should turn Amber and then on the day of the 6th month be red.
Once training has been completed and the new date input should turn green again and repeat.
I hope this makes sense, I'm sure it's probably quite basic but all of my excel training has been self taught from youtube/Google so please be kind.
I'm thinking it's something with using =today but can't quite figure it out, I'm hoping your expertise will be able to help me.
Many Thanks All
Yewkey