Thread: validation rule
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default 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?