Change the formatting of a cell based on the value of another cell
I have a sheet where I continuously add new rows, one of the column contains a local menu with 7 choices in them. Based on which value is selected in that column I want the whole row to have a given background color.
I am able to set up rules for cell formatting for that column, for example if the selected value in the local menu is "Posted" I paint that cell green, if it's "Paid" it's painted yellow. But I want that green or yellow color to apply to the whole row not just the column that contains the value. So if I change the value in that column from Paid to Posted I want the whole row to change from yellow to green.
How do I do that?