LinkBack URL
About LinkBacks
IŽd need help to make a data validation formula for the following:
I want the user to only be able to enter any value into cell D1 if the cell A1 has a value "X" and cell B1 has a value "Y" and cell C1 has a value "Z".
Many thanks for your help!
IŽd need help to make a data validation formula for the following:
I want the user to only be able to enter any value into cell D1 if the cell A1 has a value "X" and cell B1 has a value "Y" and cell C1 has a value "Z".
Many thanks for your help!
Use the below in D1 cell Data Validation Custom Formula.
Formula:
Please Login or Register to view this content.
UNCHECK the IGNORE BLANK check box.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Dear SixthSense,
Thank you for the help!
RRR
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks