Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I set up a validation rules with two data rules
I am trying to creat a validation rule that is: End date greater than date
entered in cell C23 and less or equal to 5/21/06. What I don't understan is how to set up the second rull less or equal to 5/21/06. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I set up a validation rules with two data rules
Hi Trudy,
Data, Validation and choose 'Date' in top box. Select 'between' in next box. Click into the Start date box and then click on C23. In the End date box, type =5/21/2006. Click OK and it should work -- Hope this helps, MarkN "Trudy" wrote: I am trying to creat a validation rule that is: End date greater than date entered in cell C23 and less or equal to 5/21/06. What I don't understan is how to set up the second rull less or equal to 5/21/06. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
data validation | Excel Worksheet Functions | |||
Data Validation Rules | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
named range, data validation: list non-selected items, and new added items | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |