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.


"Carmen" wrote in message
...
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!?