I have a dropdown list at the end of a row and when I select an option from the dropdown i want all the cells in the row to be filled a particular colour depending on which option I have selected.

E.g

I select "Sale" from the dropdown so I want that row to automatically fill green.

Hope someone can help, this might be a tough one.