How to colour and restrict editing based on specific value in a given cell

Hi All,

I need forum's advice on the practical issue that currently I am facing. I control a main file, which tracks the progress of each incident that is assigned to our queue. Before resolving each incident, the assigned resource needs to complete 10 checks. Once they compile their observations against each of these 10 checks, they will resolve the incident and will update the incident as resolved. On my part, I had kept this file as shared and daily add new incidents in the excel file and I will put the name of the assignee. The assignee when he/she opens the file, will check the items in their name and then they will put "YES/NO" against each of these 10 checks and finally will update the status of the incident as "RESOLVED".

As this file is used for multiple purposes, I need to ensure that the checks performed by individual members should not be altered, once they update the file.

So, here is my question, that I need forum's opinion;

a) Before the assigned resource updates the status column of the incident as "RESOLVED", it should pop up an error message to them that they should mandatorily fill some value against all the 10 cells and
b) When they finally update "RESOLVED", after compiling inputs against all the checklists, then all cells for the 10 checklist should be coloured to say Green or any desired colour and they should be blocked to them for further editing.

Would be kind if somebody advices.

Regards

sudha1974

always attach sheet in which u r working