I want to allow any entries in cells A1, A2 & A3 only if "X" has been entered in cell B1.
Regards,
--j
I want to allow any entries in cells A1, A2 & A3 only if "X" has been entered in cell B1.
Regards,
--j
Use data validation, custom formula in cells A1, A2, A3. The formula will be
=$B$1="X"
Note that this will prevent entry into those cells to begin with, but if B1 is changed to something other than X, data already entered in those cells will remain.
Direct hit! Works very nicely! I did get tripped up for a minute - needed to uncheck ignore blanks in my situation.
THANKS!
You're welcome! Thanks for the rep, and thanks for marking your thread Solved!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks