I have a table where by I want to colour code column names "WIS Completed" depending on whether status of facilities (Data Modelling, Data Logistics, RPT, NC, Paint, Trim, Composites and Model Shop( is "Pending" "Problem" "WIP" "Accepted" "Completed" etc.
Ultimately If 1 status is “Stopped”, “Problem” or “Rejected” Cell “WIS Completed” is to be RED
If no status' are “Stopped”, “Problem” or “Rejected” but 1 status is “Accepted”, “Pending” or “WIP” Cell “WIS Completed” is to be YELLOW
If no status “Stopped”, “Problem”, “Rejected”, Accepted”, “Pending” or “WIP” and 1 status is “Completed” Cell “WIS Completed” to be GREEN