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

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.

Please take a moment to re-read forum rule #1 and then amend your thread title to something that better explains your problem. Changing your thread title is not optional, which means you must change it. Thanks!

• Use concise, accurate thread titles.
  
• Your post title should describe your problem, not your anticipated solution.
• Use terms appropriate to a Google search - poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice tell us nothing.
• Responding to a request to change your thread title by doing so is mandatory.

To change a title go to your first post, click EDIT then Go Advanced and change your title.

No help to be offered, please, until the OP complies with this request.

Thanks for the title change, which is fine now. I am removing your test post as you have now learnt how to quote sections of posts. However, don't quote when replying directly to another post - it's not necessary.

Rule 08: Cross-posting Without Telling Us

Your post does not comply with Rule 8 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question. If you have fewer than 10 posts here, you will not be able to post a link, but you must still tell us where else you have asked the question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Expect cross-posted questions without a link to be closed and a message will be posted by the moderator explaining why. We are here to help so help us to help you!

Read this to understand why we ask you to do this, and then please edit your first post to include links to any and all cross-posts in any other forums (not just this site).

If you have less than 10 posts, do not try to copy and paste the link. Instead, type the link out in your thread.

No further help to be offered, please, until the OP has complied with this request.

It's not prohibited, but it's only allowed if you provide the links requested. Without them, nobody is allowed to help you. You have to abide by the rules of this forum, which have been explained to you politely in post #5. You cannot decide to ignore that request. If you do, then expect to have your thread closed. It's up to you.

Thank you for the link.

pink: J9="" applied to J9:Q24
Red: =AND(K9>0,K9-NOW()<0) applied to: =$K$9:$K$24,$M$9:$M$24,$O$9:$O$24,$Q$9:$Q$24
yellow: (K9+90)>NOW() applied to: =$K$9:$K$24,$M$9:$M$24,$O$9:$O$24,$Q$9:$Q$24
green: k9>0applied to =$K$9:$K$24,$M$9:$M$24,$O$9:$O$24,$Q$9:$Q$24
white: k9>0 applied to: =$J$9:$J$24,$L$9:$L$24,$N$9:$N$24,$P$9:$P$24