User Profile
Sarap75
Copper Contributor
Joined Jun 13, 2022
User Widgets
Recent Discussions
Conditional Formatting help
I have a spreadsheet that shows the employees who have masks assigned to them. They are to have yearly annual services, I would like for those who are out of test date to show in red, those who are in test date in green and for it to change colour to amber when they are 1 month from being out of test date. I would like this to automatically update each year Is there a way that I can get it to recognise the older dates and calculate with todays date to show the out of date one's and also the current in date ones? This is an example of how the spreadsheet is currently 393-394 17/10/2019 103898 JAVAID 395-396 09/11/2021 104615 LUCAS 397-398 16/10/2021 104214 MARSHALL 399-400 23/10/2018 104079 MURPHY 401-402 16/12/2020 104284 MILLS 403-404 19/07/2021 104230 WEBSTER 405-406 01/04/2021 104204 SARGESON Thanks Sara840Views0likes1Comment
Recent Blog Articles
No content to show