Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Conditional Validation In Excel
I'm trying to create a sort of "validation if" in an excel sheet.
In cell A1, I have three choices, "A" "B" and "C" which a user can select from a drop down list. Let's say the user selects "A." I want to set up the validation so that if today is past a certain date (a date listed in cell B2), then cell A1 will automatically change to "B" instead of "A." A B 1 a/b/c date 2 3 4 Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional validation | Excel Programming | |||
How do I link a conditional list in MS Excel Data validation? | Excel Discussion (Misc queries) | |||
How do I do conditional validation in excel? | Excel Worksheet Functions | |||
Conditional Data Validation possible in Excel 2003? | Excel Discussion (Misc queries) | |||
Conditional Validation ! | Excel Programming |