Validation of cell based on Drop down list

M

murtaza7210

I need to perform validation on column B depending on the selecte
dropdown value in column A....
I have column A with drop list whose value are
Sales Cash, Sales Credit, Purchase Cash, Purchase Credit...etc.
I want to perform validation on column B if the selection in column A i

Sales Cash, Sales Credit then column B should accept a positive valu
0,
Click to expand...
else if the selection in column A is Purchase Cash, Purchase Credit the
column B should accept a negative value <
 
C

Claus Busch

Hi,

Am Fri, 16 Nov 2012 08:17:18 +0000 schrieb murtaza7210:
Sales Cash, Sales Credit then column B should accept a positive value
else if the selection in column A is Purchase Cash, Purchase Credit then
column B should accept a negative value <0
Click to expand...

select your range in column B => data validation => custom:
=IF(LEFT(A1,5)="Sales",B1>0,B1<0)


Regards
Claus Busch
 
Top