yes i want to deny entery in A1if B1 has a value and to deny entry B1 if A1
has a value. it will need to be extended down the columns.

regards
nader

"Rick Rothstein" wrote:

More information please... Do you want to deny the entry in A1 if B1 has a
value, or are you just looking for the alert only (same question for B1/A1
also)? Will this functionality apply only for A1 and B1, or will it need to
be extended down the columns?

--
Rick (MVP - Excel)


"nader" wrote in message
...
hi
i want when i insert a value in cell a1, if cell b1 have value i get alert
and when i insert a value in cell b1, if cell a1 have value i get
alerttoo.

kind regards
nader