Hi Graham,

I appreciate your help.
I think I may have not made clear that the values that are in the cells I want to auto-colourise are from a direct export from another program. These values will stay as is and I have not modified these and they will not be modified in the future.

If you already knew what I meant, then sorry, I don't mean to patronise you.

Based on this, is there a way to have a script look for:
"Weak" If "Weak" is found, colour cell "Orange". (white font)
"Effective" If "Effective" is found, colour cell Blue". (white font)
"Adequate" If "Adequate" is found, colour cell "Green". (white font)
"Not Applicable" If "Not Applicable" is found, colour cell "Purple". (black font)

Font colour change is not a necessity and if this over complicates the task then feel free to leave it out.

Regards,

Julian