Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 08-01-2015, 09:08 AM
nicholes nicholes is offline Data validation,force cell to be filed with number if respective cell is not empty Windows XP Data validation,force cell to be filed with number if respective cell is not empty Office 2007
Novice
Data validation,force cell to be filed with number if respective cell is not empty
 
Join Date: Apr 2012
Posts: 21
nicholes is on a distinguished road
Default 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
Reply With Quote
Reply

Thread Tools
Display Modes


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
Data validation,force cell to be filed with number if respective cell is not empty 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
Data validation,force cell to be filed with number if respective cell is not empty 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
Data validation,force cell to be filed with number if respective cell is not empty 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 - Senior Forums

All times are GMT -7. The time now is 09:14 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft