Here is what i’m trying to do:

I have a row of data for the members of a fitness club including name, number, city, etc. The final column then asks if they are currently a member or not using a “Yes”, “No”, or “Pending” drop down list.

I want to create a formula that checks the drop down box and if “Yes” is checked it sets the entire row to a certain background color (ie: light green), if “No” is checked then it sets the background of the entire row to red, and if “pending” is checked it sets it to light blue.

So, to summarize:
I want to set the color of an entire row depending on the value of a specific drop down menu (3 possibilities).

I got it to color the drop down menu cell a specific color depending on the result using condition formatter, but i cant figure out how to get the whole row a color. I’m thinking ill just have to create a formula on another page of my workbook and have it reference that cell using a lookup function and then execute an action depending.

Thank you for any help