Is it possible to have an alert when some info is entered
in any particular cell? for example if I enter 1 in Cell A1,
can I have an alert saying "check data in cell D4" ?

Thanks.
Mukesh

Yes, this can be done, but the only way I know of is through the use
of macros.

Mukesh,

Try using Data Validation which will do what you want. Have a play with
that and post back if you have problems.

Rob

"Mukesh" wrote in message
...
Is it possible to have an alert when some info is entered
in any particular cell? for example if I enter 1 in Cell A1,
can I have an alert saying "check data in cell D4" ?

Thanks.
Mukesh

Thanks RobN, I think Data Validation should solve
my purpose...just need to play a bit.

Thanks.
Mukesh



"RobN" wrote:

Mukesh,

Try using Data Validation which will do what you want. Have a play with
that and post back if you have problems.

Rob

"Mukesh" wrote in message
...
Is it possible to have an alert when some info is entered
in any particular cell? for example if I enter 1 in Cell A1,
can I have an alert saying "check data in cell D4" ?

Thanks.
Mukesh

RobN, using Data Validation, is it possible to have an
alert only if some criteria is not met....for example
I type some text in cell A2, which is data validation cell,
I need an alert only if A1 is empty, if its filled, move on....no alert.

If its not possible to do so using Data Validation, can you please
tell me how I can do using macros. I need alert only if the
conditions are not met.

Thanks.
Mukesh




"Mukesh" wrote:

Thanks RobN, I think Data Validation should solve
my purpose...just need to play a bit.

Thanks.
Mukesh



"RobN" wrote:

Mukesh,

Try using Data Validation which will do what you want. Have a play with
that and post back if you have problems.

Rob

"Mukesh" wrote in message
...
Is it possible to have an alert when some info is entered
in any particular cell? for example if I enter 1 in Cell A1,
can I have an alert saying "check data in cell D4" ?

Thanks.
Mukesh

Mukesh,

I don't know if my computer's gone nuts, but I thought selecting cell A2,
then selecting Custom in the Allow section of Data Validation, and typing
a1<""
in the formula section should have done it. But on my system it's not
working.

Maybe someone else can help out here, as I'm sure Data Validation will do
what you want.

Rob

"Mukesh" wrote in message
...
RobN, using Data Validation, is it possible to have an
alert only if some criteria is not met....for example
I type some text in cell A2, which is data validation cell,
I need an alert only if A1 is empty, if its filled, move on....no alert.

If its not possible to do so using Data Validation, can you please
tell me how I can do using macros. I need alert only if the
conditions are not met.

Thanks.
Mukesh




"Mukesh" wrote:

Thanks RobN, I think Data Validation should solve
my purpose...just need to play a bit.

Thanks.
Mukesh



"RobN" wrote:

Mukesh,

Try using Data Validation which will do what you want. Have a play
with
that and post back if you have problems.

Rob

"Mukesh" wrote in message
...
Is it possible to have an alert when some info is entered
in any particular cell? for example if I enter 1 in Cell A1,
can I have an alert saying "check data in cell D4" ?

Thanks.
Mukesh

Rob,

Same here, my computer too gone nuts, its not working!
Aparently, its not the computer going nuts, its the formula,
hope someone here might be able to help.

Thank you Rob for your efforts.

Mukesh



"RobN" wrote:

Mukesh,

I don't know if my computer's gone nuts, but I thought selecting cell A2,
then selecting Custom in the Allow section of Data Validation, and typing
a1<""
in the formula section should have done it. But on my system it's not
working.

Maybe someone else can help out here, as I'm sure Data Validation will do
what you want.

Rob

"Mukesh" wrote in message
...
RobN, using Data Validation, is it possible to have an
alert only if some criteria is not met....for example
I type some text in cell A2, which is data validation cell,
I need an alert only if A1 is empty, if its filled, move on....no alert.

If its not possible to do so using Data Validation, can you please
tell me how I can do using macros. I need alert only if the
conditions are not met.

Thanks.
Mukesh




"Mukesh" wrote:

Thanks RobN, I think Data Validation should solve
my purpose...just need to play a bit.

Thanks.
Mukesh



"RobN" wrote:

Mukesh,

Try using Data Validation which will do what you want. Have a play
with
that and post back if you have problems.

Rob

"Mukesh" wrote in message
...
Is it possible to have an alert when some info is entered
in any particular cell? for example if I enter 1 in Cell A1,
can I have an alert saying "check data in cell D4" ?

Thanks.
Mukesh