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?....sure can, use something similar myself.


in your Conditional Formatting Rules Manager, your current rule that changes one row, in the Applies to entry, change it to include the entire table.
for example, =$A$1:$Z$5000
when you add new rows, it'll auto update the $R$C values accordingly.