Hi All,


Is it possible to get a cell value to be displayed as an
error meessage in a data validation?

for eg if i have limited the number in A1 to be equal or
multples of B1 how can i get an eror message somethinf
like "amount should be multples of " & B1.value
(the value in B1 may vary)

TIA
Soniya