Hi guys,
First of all, please try to forgive me for my bad English as it's not my native language.
You see, I have this excel training spreadsheet where I want to do the following:
1. Highlight both cells (Non-compliant & Complaint columns) with a specific colour (let's just say pink) if it's empty (no date or whatsoever);
2. If there is a date on complaint column (meaning the person attended the courses), then the complaint column turns to a green colour and a non-compliant column turns a standard white colour;
3. If there is a date (let's just say 2018/09/15) then the cell turns yellow because the course is going to expire less then 3 months
I have attached the soft copy of the spreadsheet I am working on. If possible, can any of you work on the bottom row (GEORGE MICHAEL - highlighted in yellow) to see/test if it works?
Hope you can make this work and advice on how to solve this in the simplest way possible.
Thank you, much appreciated.
Bookmarks