| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
change value in a cell if other cell is changed
I have columns A and B that look like this:
5 80 5 79 5 81 etc... Now, what I want is to delete the value in column B if th corresponding value in column A is not 5. This doesn't seem to b difficult, but the problem is that I want the value in column B t return to default value if it's corresponding value in column A i changed back to 5. Is this possible -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need to clear cell values, when a different cell is changed. | Excel Discussion (Misc queries) | |||
| Format changed when the details in cell changed | Excel Worksheet Functions | |||
| Change Colour on a Cell after another cell has been changed | Excel Discussion (Misc queries) | |||
| in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? | Excel Worksheet Functions | |||
| Cell comment boxes shouldn't change size/shape unless changed by u | Excel Discussion (Misc queries) | |||
![dreamer[_11_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
