I have two columns:
H J
Date Quarter
The both columns have a validation: Date is checking that entries should be
in the date format; Quarter is linked to a list of quarters and checking that
the entry is from that list.
However, I'd like to have some checking between these columns as well for
the dates matching with quarters. E.g., if Date is 1/1/2005 in H2 the user
should choose only Q1 from the list in J2.
How could I do it?
Thanks
Bookmarks