View Single Post
  #2   Report Post  
wickedchew wickedchew is offline
Senior Member
 
Location: Philippines
Posts: 161
Default

Quote:
Originally Posted by dalymjl View Post
I would like to apply a custom validation to ensure that the input value in a cell is equal to or an exact multiple of a value in another cell. For example, if the reference cell contains the value "2" then the only valid entry in the input cell should be 2,4,6,8,10 etc. (Zero should also be valid). Is this possible?

Thanks

dalymjl
Hope the attachment helps.
Attached Files
File Type: zip Data Validation.zip (4.3 KB, 48 views)
__________________
Asobi Wa Owari Da