| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Clearing a cell based on the value of another cell (INDIRECT data) without macros
Hi All. First thread so be gentle.
Excel 2007 I am using the INDIRECT function in Data Validation to drive the drop-down values available to users. A selection is made in K34 that drives the available options in M35. The problem I have is that if a user goes back to K34 and changes their selection, the option they have chosen remains in M35. That option may now be invalid as the new selection in K34 has a different option set. I need a way to blank M35 if a new selection is made in K34. I can't put a formula directly into M35 as it is user selectable and I can't use code or macros (customer security policy). I'm currently using Conditional Formatting to change font to white when K34 is empty but of course they re-appear when K34 is changed (still with the wrong options in place). Any ideas? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| vba line for clearing data from a cell | Excel Discussion (Misc queries) | |||
| Changing Cell Background Color based on data from another cell | Excel Discussion (Misc queries) | |||
| Highlight Cell Based Upon Referenced Cell Data | Excel Worksheet Functions | |||
| Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
| How do I change cell color based upon data range within the cell? | Excel Worksheet Functions | |||
Linear Mode
