| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formating for the whole row, based on one cell val
Thank you Jacob!
Now it perfectly works! "Jacob Skaria" wrote: 1. Select the cell/Range (say A6:J6) 2. From menu FormatConditional Formatting 3. For Condition1Select 'Formula Is' and enter the below formula =$G6="Closed" 4. Click Format ButtonPattern and select your color (say Grey) 5. Hit OK -- Jacob "Renata" wrote: I have applied conditional formating to cell G6, when I choose value "Closed" from drop down menu for this cell, it gets huighlighted in grey. I would like the range A6:J6 to get highlighted in grey as well. How do I apply this part in Excel-2003? Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formating based on blank cell | Excel Worksheet Functions | |||
| Conditional Formating based on a different cell | Excel Discussion (Misc queries) | |||
| Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
| Set conditional formating for cell based on value in different cel | Excel Discussion (Misc queries) | |||
| Conditional Formating based on another cell | Excel Discussion (Misc queries) | |||
Threaded Mode
