Forum Discussion

Sarap75's avatar
Sarap75
Copper Contributor
Jun 14, 2022

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-39417/10/2019103898JAVAID
395-39609/11/2021104615LUCAS
397-39816/10/2021104214MARSHALL
399-40023/10/2018104079MURPHY
401-40216/12/2020104284MILLS
403-40419/07/2021104230WEBSTER
405-40601/04/2021104204SARGESON



Thanks Sara