Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Data Validations
Is there a way to set up a data validation where a different message would
pop up depending on the date you entered in the cell? What I'm trying to do is if a request date is within two weeks of the todays date(entered on a different cell), then it will tell you to go to step 4. If it's after two weeks from today's date , then it will tell you to go to step 6. Know how to do with one date range using data validation. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Data Validations
Personally, I think I'd use a helper cell with a formula in it that determines
the message and displays it. within two weeks??? =if(abs(today()-a1)<=14,"message1","message2") Supe wrote: Is there a way to set up a data validation where a different message would pop up depending on the date you entered in the cell? What I'm trying to do is if a request date is within two weeks of the todays date(entered on a different cell), then it will tell you to go to step 4. If it's after two weeks from today's date , then it will tell you to go to step 6. Know how to do with one date range using data validation. Is this possible? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
two data validations for same cell | Excel Discussion (Misc queries) | |||
two data validations for same cell | Excel Discussion (Misc queries) | |||
data validations | Excel Discussion (Misc queries) | |||
3 data validations | Excel Worksheet Functions | |||
Multiple Validations in for 1 cell | Excel Worksheet Functions |