Conditional Formatting an entire row based on one cell's value.

[Carmen]

I want the rows of my spreadsheet to be a certain color, based on one
column's values, for example, if column B contains the text, "Carmen", I want
the whole row to be green. If column B contains the text "Agnes", I want the
row to be yellow. Please help!?

 

[Gaurav]

1. Select your row. for example B2:Z2

2. Go to Format | Conditional Formatting

3. in the first drop down select FORMULA IS

4. in the second box enter =$B2="carmen"

5. Click format | pattern tab | select the color | press OK

6. Now click on ADD

7. Repeat step 3, 4 and 5 (change "carmen" to "Agnes" in step 4)

8. Press OK

9. Copy the row.

10. Select all the columns and rows (entire data range)

11. Right click | Paste Special | Values | OK


hope that helps.

 

[Gaurav]

Correction : Step 11

Right click | Paste Special | Format | OK

Thanks

 

[Carmen]

Thank you so much for the help, very easy to follow your directions!

 

[Gaurav]

I'm glad I could help. Thanks for the feedback.

Thank you so much for the help, very easy to follow your directions!