MrsSurg
New Member
- Joined
- Nov 6, 2023
- Messages
- 7
- Office Version
- 365
- Platform
- Windows
Hi all,
I have two completely separate files/spreadsheets saved with different names. I am wanting one file/spreadsheet to automatically colour code a cell when a certain timeframe has passed from the date on the second file/spreadsheet.
For example - we are using this for training records, first file is a Master List with all staff names and hyperlinks to their individual training spreadsheet. They are required to do training on 1 day then an audit 3 days later.
I would like to be able to look at the Master List and that having automatically coloured the cells with the names of the staff who are due their audit (being 3 days from their training date).
Is this possible?
Thanks so much =)
I have two completely separate files/spreadsheets saved with different names. I am wanting one file/spreadsheet to automatically colour code a cell when a certain timeframe has passed from the date on the second file/spreadsheet.
For example - we are using this for training records, first file is a Master List with all staff names and hyperlinks to their individual training spreadsheet. They are required to do training on 1 day then an audit 3 days later.
I would like to be able to look at the Master List and that having automatically coloured the cells with the names of the staff who are due their audit (being 3 days from their training date).
Is this possible?
Thanks so much =)