Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 2
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,872
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to dynamically change the list in drop down list based on thevalue of another cell? [email protected] Excel Programming 1 September 6th 12 01:03 PM
changing validation drop down based on another cell value pawlingJohn Excel Programming 5 January 16th 09 10:56 PM
Data validation list drop-down values based on prior selections David Excel Programming 2 September 26th 08 03:58 PM
Data Validation - In cell drop Down List VandyBill Excel Discussion (Misc queries) 1 January 17th 08 03:34 PM
Default Cell Value with Validation Drop-Down List Dave H Excel Discussion (Misc queries) 0 January 30th 06 09:58 PM


All times are GMT +1. The time now is 03:18 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"