Hey ..
I've been having this issue. I've tried alot of things but nothing seems to work.
In Column G I've a Data Validation Drop Down List with "BB" And "BS" as two options. For every "BB" or "BS" in Column G there is an Amount in Column H
.
What I want is.
Incase the option "BS" is selected in Column G only an amount greater than 0 can be entered in Column H.
Incase the option "BB" is selected in Column H only an amount less than 0 can be entered in Column H.
Is this possible using Data Validation or any other technique ?
Bookmarks