| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation Question
I have set up Data Validation in cell Q10 that only allows text entered into
it if cell M10 is equal to "Offer Declined". I have noticed though if you put the status of M10 to "Offer Declined", then go to Q10, enter text, then change the status of M10 to something else, it still allows the text. I was wondering if there was something that I could do that would remove the text in Q10 if M10 changes to anything other than "Offer Declined". Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation Question? | Excel Worksheet Functions | |||
| Macro question | Excel Worksheet Functions | |||
| Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Data validation question | New Users to Excel | |||
Threaded Mode
