Mar 28 2023 07:02 AM
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 if the same column 'E' entry is 'Hours' then i only want to be able to enter hh:mm style entry in that 'j' cell.
Mar 28 2023 07:11 AM
You can use data validation in Excel to restrict data entry based on another column.
You can create two lots of data validation in one column based on another column by using a custom formula.
Here’s how you can do it:
This formula will allow you to enter a date in column J if column E contains “Calendar”
and will allow you to enter a time value in column J if column E contains “Hours”.
I hope this helps!
Mar 28 2023 07:17 AM
Mar 28 2023 07:21 AM
Mar 28 2023 07:24 AM
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.