Data validation,force cell to be filed with number if respective cell is not empty

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Data validation,force cell to be filed with number if respective cell is not empty

FAQ

Thread Tools

Display Modes

08-01-2015, 09:08 AM

nicholes

Windows XP Data validation,force cell to be filed with number if respective cell is not empty

Office 2007

Novice

Join Date: Apr 2012

Posts: 21

Data validation,force cell to be filed with number if respective cell is not empty

Hi,

How do i make B2 cell force to only filled with numbers if A1 cell is not empty?

in other words i want to force B2 cell to be filled with any number, but only on condition if A1 cell is not empty.

I mean if user type anything in A1 he must have to fill B2 also with number

or I want > no user can fill A1 cell alone but he has to fill B2 also with number

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to create a data validation based on another cell's value??	cfreezy	Excel	1	06-18-2015 09:51 AM
Entering a number in a cell causes it to fill with the color of a nearby cell	Bill Martz	Excel	1	04-23-2015 07:57 PM
If id cell range is empty then should not allow to fill any other cell	ubns	Excel Programming	2	04-12-2015 06:31 AM
Restrict data validation based upon a cell value	Strategic	Excel	2	01-27-2015 02:13 AM
validation email address in word text filed	sameerahmad_P	Word VBA	1	03-07-2014 02:59 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:50 AM.