validation rule

  • Thread starter Thread starter angie
  • Start date Start date
A

angie

column A and column B contain numbers. i want to prevent users from entering
e.g. data in B2 if it is smaller than the A2. how can i achieve that?
 
Select column B then Data>Validation>Choose Custom validation from drop
down list and enter =B1>=A1 in formula field.
Regards,
Stefi

„angie†ezt írta:
 
Back
Top