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
Bookmarks