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

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

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

Give this a try. You will do this one at a time for each column... we'll do
Column A first.

If you want this functionality for the entire column, then select the entire
Column A; otherwise select all of the cells in Column A that you will want
to have this functionality and note the active cell within that selection
(I'll assume it to be A1). Now, click Data/Validation from the menu bar. On
the Settings tab, select "Custom" from the "Allow" drop down; then put the
following formula in the "Formula" field...

=LEN(B1)=0

Note that if you used a partial selection of Column A and the active cell
was not A1, then you need to use the row number from that active cell in the
above formula (that is, if the active cell was A7, the use =LEN(B7)=0 in the
formula instead). Also make sure the "Ignore blank" check box is checked.
While the dialog box is up, you can customize the message that appears if
the corresponding cell in Column B has a value in it via the "Error Alert"
tab. The "Input Message" tab is used if you want to display a message the
validation cell is selected.

Now, repeat the above procedure for Column B, although you will use this
formula for it...

=LEN(A1)=0

--
Rick (MVP - Excel)


"nader" wrote in message
...
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

thanks a ton for your support.
best regards
nader

"Rick Rothstein" wrote:

Give this a try. You will do this one at a time for each column... we'll do
Column A first.

If you want this functionality for the entire column, then select the entire
Column A; otherwise select all of the cells in Column A that you will want
to have this functionality and note the active cell within that selection
(I'll assume it to be A1). Now, click Data/Validation from the menu bar. On
the Settings tab, select "Custom" from the "Allow" drop down; then put the
following formula in the "Formula" field...

=LEN(B1)=0

Note that if you used a partial selection of Column A and the active cell
was not A1, then you need to use the row number from that active cell in the
above formula (that is, if the active cell was A7, the use =LEN(B7)=0 in the
formula instead). Also make sure the "Ignore blank" check box is checked.
While the dialog box is up, you can customize the message that appears if
the corresponding cell in Column B has a value in it via the "Error Alert"
tab. The "Input Message" tab is used if you want to display a message the
validation cell is selected.

Now, repeat the above procedure for Column B, although you will use this
formula for it...

=LEN(A1)=0

--
Rick (MVP - Excel)


"nader" wrote in message
...
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