ExcelBanter - validation rule

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - validation rule (https://www.excelbanter.com/excel-programming/426605-validation-rule.html)

Angie

validation rule

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?

Stefi

validation rule

Select column B then DataValidationChoose Custom validation from drop
down list and enter =B1=A1 in formula field.
Regards,
Stefi

€žangie€ ezt Ã*rta:

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?

All times are GMT +1. The time now is 12:14 AM.