Hi All,

I have three 4 columns, (A,B,C,D) and a status column. There are four colour assigned to the ratings (Good, Fair, Bad, Poor). For every column there will be a colour, now the status column should be filled with the worst colour from the 4.

Please find the attachment for reference.

Thanks in advance.

try.xlsx