I have 3 cell : f2 ,g2 and h2
I want to input ONLY ONE of this 3 cells.(Only One is permited , but other two cells to be locked to input)
Example: If G2 and/or H2 is filled with numbers, F2 must be prevented to input a number.
Same condition is valid for G2 and H2 cells.
How can it be solved with Custom Data Validation ( or simple macro)
F2, G2, H2 cells going down to 4000th rows with same condition.
Thanks in advance for any reply and help.
Regards,
turist
Bookmarks