I am creating a table for work, I order parts for a mechanics shop. My table is basic, it has a columns for prices, vendors and status. In my "Status" column, I have a drop down menu with the following options: Researching, Pending, Ordered, Shipped, and Complete. What I am looking for is, when I choose an option in the "status" column I want the entire row to change colour. EX: If I choose 'Pending, in row 15, all of row 15 changes to blue, and if I choose 'Shipped' in row 13 all of row 13 turns green.
I know how to do this row by row with conditional formatting, my problem is I want to do it for the entire table which has 500 rows. Is there a way to apply to rule to the entire table without having to go row by row?