| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Update the row when type at a cell
You could do that with conditional formatting.
In Excel, select the row. Format menu - Conditional formatting Formula is: =$A2="Done" choose a format etc -----Original Message----- Hi Experts out there, I would like to seek for your help. I am trying to write some codes that will update the entire row color when certain word is type in a particular cell. For Example, I am using Column A as the status check. WHen I type "Done" in the the cell A2, then I want the entire row 2 to be highlighted in grey. How do I go about doing this? MANY THANKS IN ADVANCE... LSB . |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
| Type in one cell and data copies into another cell | Excel Discussion (Misc queries) | |||
| Type 3 digits in one cell then automatically move to next cell. | Excel Discussion (Misc queries) | |||
| type MI in cell, have Michigan show in adjacent cell | Excel Discussion (Misc queries) | |||
| Type into one cell and automatically clear contents in another cell | Excel Programming | |||
Threaded Mode
