Thread: Data Validation
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dom_Ciccone Dom_Ciccone is offline
external usenet poster
 
Posts: 52
Default Data Validation

Minor correction:

=AND(A1<"",A2<=A1)

This will allow A2 to be equal to or less than A1, but not exceed.

"ollie" wrote:

I am looking for a formula to place in Data Validation / Custom so that an
amount cannot be placed in cell a2 unless a1 has a value in it and the value
in a2 must not exceed the value in cell a1.