| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting an entire row based on one cell's value.
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!? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting an entire row based on one cell's value.
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!? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting an entire row based on one cell's value.
Correction : Step 11
Right click | Paste Special | Format | OK Thanks "Gaurav" wrote in message ... 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!? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting an entire row based on one cell's value
Thank you so much for the help, very easy to follow your directions!
"Gaurav" wrote: Correction : Step 11 Right click | Paste Special | Format | OK Thanks "Gaurav" wrote in message ... 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!? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting an entire row based on one cell's value
I'm glad I could help. Thanks for the feedback.
"Carmen" wrote in message ... Thank you so much for the help, very easy to follow your directions! "Gaurav" wrote: Correction : Step 11 Right click | Paste Special | Format | OK Thanks "Gaurav" wrote in message ... 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!? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting based on entire column | Excel Worksheet Functions | |||
| Conditional Formatting for Rows based on one cell's outcome | Excel Discussion (Misc queries) | |||
| Conditional Format based on other cell's value | Excel Worksheet Functions | |||
| Applying conditional formatting to cell based on another cell's in | Excel Discussion (Misc queries) | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
Linear Mode
