condditional farmulation

  • Thread starter Thread starter RAMAN
  • Start date Start date
R

RAMAN

sir, i want to do in excel such type of farmla through we can not leave blank
cell or enter without giving number.
like :

1
2
4
if we can not enter 3 than cursor is not enter in next cell
 
Hi,

You may select the range where you want the user to enter the number and
then go to Data > Validation > Allow > Whole Numbers and then specify the
range. Click on OK.

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
 
Back
Top