Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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

conditional formatting dialog

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.

share|improve this question
possible duplicate of Conditional formatting to highlight the whole row – Excellll Jul 10 '14 at 17:19
@Excellll: The duplicate you refer too - does this work with multiple conditions as well and not just a single true/false condition. I need multiple colors. – juergen d Jul 10 '14 at 17:21
You have to a set up a rule for each value/color combination. Each rule should be like what's described in the linked duplicate. – Excellll Jul 10 '14 at 17:22
The answer in the duplicate question seems to be too advanced for me. I don't know about that dialogs they are talking about – juergen d Jul 10 '14 at 17:48
up vote 0 down vote accepted
  • 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

conditional formatting dialog

share|improve this answer
If this answers your question, don't forget to mark it as the accepted answer, by clicking on the checkmark on the left side of the question. – Doktoro Reichard Jul 20 '14 at 21:43

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.