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:
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup formula problemo 2
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Excel If a Cell Contains a Certain Text (From Another Table) 0
A data validation question 1
Macro for Creating Word Document!! 5
Array VLOOKUP lookup_Value does not increment 3
Deleting characters in a column of cells -converting to text strin 2
Excel Conditional Formatting 1

Back
Top