Share via

Excel help - conditional formatting

SaraP 1 Reputation point
2022-06-10T07:49:46.913+00:00

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

This is how it looks,
210137-image.png

Microsoft 365 and Office | Excel | For business | Windows
Developer technologies | Visual Basic for Applications

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.