Forum Discussion
Excel multiple data validation
I want to create two lots of data validation in one column based on another column. If i enter 'Calendar' in to column 'E' i want to only be able to enter a date in to the same row in column 'J'. But...
Thanks, i think it was the 'ISDATE' and 'TIMEVALUE' bits that i was struggling with.
Nice to hear that you made progress with your project.
I wish you continued success with Excel.
I wish you continued success with Excel.
Ignore that no i get a 'named range cannot be found' error. The 'Calendar' and 'Hours' i put are just drop down options in a list. Will this mean that the formula cannot see them? Although i thought that is what the quotation marks were for.