Need some help with combining a custom data validation and a list validation in the same cell.
Information in cell B2 can't be entered until cell A2 is entered. This continues thru cell F2. I am using this formula:
Information in G2 can't be entered until F2 is entered and the input can only be Yes or No. I tried this formula in G2, but only half of it worked:
=AND(ISBLANK(F2),OR(G2="Yes",G2="No"))
Information in H2 can't be entered until G2 is entered and the input can only be 1,2,3,4,Safe or HR.
I have attached what I am working on.
Thanks for helping.
Bookmarks