Conditional Data Validation Amount

**Meunixx** · 07-11-2013, 01:07 PM

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 ?

**benishiryo** · 07-11-2013, 09:58 PM

hi Meunixx, welcome to the forum. yes you can use Data Validation. say you want it in H2:H10.
1. select from H2:H10
2. go to Data -> Data Validation -> Allow: Custom -> Formula:
=IF(G2="BB",H2>0,H2<0)
3. press OK & you are done

**Meunixx** · 07-12-2013, 04:26 AM

Thanks .. I tried the same thing my self but it didn't work. May be had some coding wrong ..

Thanks Anyways

**Meunixx** · 07-12-2013, 04:47 AM

Thanks .. I tried the same thing my self but it didn't work. May be had some coding wrong ..

Thanks Anyways

**Meunixx** · 07-12-2013, 12:12 PM

Sir,

The problem is solved.
But now there seems to be another problem.

Suppose if I enter "BB" in column G and enter an amount less than 0 in Column H it'll accept it.
But then after entering a (-) amount I change "BB" to "BS" its still accepting it without giving any error.

Is it possible to plugin this loophole ?