Excel: Different background colors on condition

Question

The problem

I have a Excel sheet that contains a status column.

Number  Status              Name
-------------------------------------
     1  not implemented     feature 1
     2  completed           feature 2
     3  new                 feature 3
     4  open                feature 4

I want each row have a different background color depending on the cell value of column status.

My attempt

I tried chosing conditional formatting->new rule. This dialog pops up

but I can't find a setting that both applies to the complete row and let my define a rule for different colors depending on a specific cell value.

Answer 1

• Select all cells of your sheet
• Open conditional formatting -> new rule
• Choose the last entry in the list.
• Define your cell value with leading $. Only the column name is important, the row can be random. For instance =$B1="not implemented"
• Choose a color for this setting by selecting "format"
• For each color define a seperarte rule