How to highlight a specific cell based on value/text/number

[Byambadorj]

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; - basically if there is no data entered, it's pink and if compliant column has data it turns green and no complaint column is white.
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 in less then 3 months

Hope you can make this work and advice on how to solve this in the simplest way possible.

 

[jtakw]

Hi,

Since your sample is uploaded at your cross-post, I posted a response there.