View Single Post
 
Old 08-01-2015, 09:08 AM
nicholes nicholes is offline Windows XP Office 2007
Novice
 
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