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.

 

[Fluff]

Cross posted https://www.excelforum.com/excel-ge...l-based-on-value-text-number.html#post4936588

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[Byambadorj]

Okay noted. But since you do not prohibit, not illegal or against the law of any country, also since the other thread has no helpful response i'll just leave it here as it is until someone can help me?

 

[Byambadorj]

Guys, this is the similar post I made on another forum Excel Forum. I'll just put this here https://www.excelforum.com/excel-ge...l-based-on-value-text-number.html#post4937276
I am happy to comply with the rules and get assistance from the experts on my issue


Thank you

 

[Fluff]

Having looked at the files you supplied on EF.
You have a number of cells which use a custom function to count coloured cells.
If you use CF then those formulae/functions will no longer work.

 

[Byambadorj]

So is there no way to make it the way I want it???

 

[Fluff]

You would have to change all the functions to formulas based on the Cf criteria.

 

[Byambadorj]

Can I get the similar result? If yes, could you pls help me how???

 

[Fluff]

I'm afraid formulae are not my strong point & I wouldn't now where to start.

 

[Byambadorj]

Can anyone able to assist me on this, pls?