|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
|
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 |