Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Validation of cell based on Drop down list
I need to perform validation on column B depending on the selected 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 is Sales Cash, Sales Credit then column B should accept a positive value 0, else if the selection in column A is Purchase Cash, Purchase Credit then column B should accept a negative value <0 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Validation of cell based on Drop down list
Hi,
Am Fri, 16 Nov 2012 08:17:18 +0000 schrieb murtaza7210: Sales Cash, Sales Credit then column B should accept a positive value 0, else if the selection in column A is Purchase Cash, Purchase Credit then column B should accept a negative value <0 select your range in column B = data validation = custom: =IF(LEFT(A1,5)="Sales",B10,B1<0) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to dynamically change the list in drop down list based on thevalue of another cell? | Excel Programming | |||
changing validation drop down based on another cell value | Excel Programming | |||
Data validation list drop-down values based on prior selections | Excel Programming | |||
Data Validation - In cell drop Down List | Excel Discussion (Misc queries) | |||
Default Cell Value with Validation Drop-Down List | Excel Discussion (Misc queries) |