MikeMcCollister
Board Regular
- Joined
- May 6, 2020
- Messages
- 71
- Office Version
- 365
- Platform
- Windows
I have three adjacent cells which I want to restrict numbers to be entered into only one. So I have a data validation scheme setup so that I am using for cell A2
If I have "Ignore blank" checked, this does not work, as shown here. Why is that?
Thanks,
Mike
Excel Formula:
=AND(ISNUMBER(A2), ISBLANK(B2), ISBLANK(C2))
If I have "Ignore blank" checked, this does not work, as shown here. Why is that?
Thanks,
Mike