Hello everybody,

How can I get a warning message, if I enter any text in A1 and left B1
blank and proceeded to C1?

Appreciate any help in advance

Thanks

DC

Hi DC

One option is to set a conditional format in C1.

eg Formula Is =AND(A1<"",B1="") and set FormatPatterns to a background
colour.

--
Ian
--
"Dileep Chandran" wrote in message
oups.com...
Hello everybody,

How can I get a warning message, if I enter any text in A1 and left B1
blank and proceeded to C1?

Appreciate any help in advance

Thanks

DC

One possibility is a graphical warning, applied with conditional formatting.

Example: if you want to be alerted whenever B1 remains blank you could apply
to C1 the following conditional formatting:

Format--Conditional Formatting

Condition 1: Formula is: =ISBLANK(B1) and have the color displayed a bright,
garish color.

If you want an actual dialogue box to pop up, with a text message telling
you that B1 is blank, then you would have to write some code.

Dave


--
Brevity is the soul of wit.


"Dileep Chandran" wrote:

Hello everybody,

How can I get a warning message, if I enter any text in A1 and left B1
blank and proceeded to C1?

Appreciate any help in advance

Thanks

DC

Select the B cells in question
Use Format | Conditional Formatting
Use Formula is: =AND(NOT(ISBLANK(A1)),ISBLANK(B1), NOT(ISBLANK(C1)))
and set a pattern (bright red?)
If A and C are not blank while B is the cell with have a bright colour.
Any good?
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dileep Chandran" wrote in message
oups.com...
Hello everybody,

How can I get a warning message, if I enter any text in A1 and left B1
blank and proceeded to C1?

Appreciate any help in advance

Thanks

DC

Thats good enough. Thank you. But is it possible to get a pop up
warning for that, using a macro?

I think, my question is not clear. I am looking for a pop up message,
like what we get if the cell has a data validation.

Anyway, thank you for all your help

Post the question to the Excel programming newsgroup
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dileep Chandran" wrote in message
ups.com...

I think, my question is not clear. I am looking for a pop up message,
like what we get if the cell has a data validation.

Anyway, thank you for all your help

Hi Dileep, I've got the nearest thing for you without requiring coding, using
Data Validation.

Set your validation in Cell C1 as 'Custom' and use the same code as
mentioned earlier: =AND(A1<"",B1="") and ensure the tickbox "ignore blank"
is unticked.

Simply use the 'error message' tab to create something like: "Ensure you
type in cell A & B" and that should present you with an error dialogue box
you were after :)

Hope that was ok.

Jonathan


"Dileep Chandran" wrote:


I think, my question is not clear. I am looking for a pop up message,
like what we get if the cell has a data validation.

Anyway, thank you for all your help

Sorry that should have been: =AND(A1<"",B1<"")

"Jonathan" wrote:

Hi Dileep, I've got the nearest thing for you without requiring coding, using
Data Validation.

Set your validation in Cell C1 as 'Custom' and use the same code as
mentioned earlier: =AND(A1<"",B1="") and ensure the tickbox "ignore blank"
is unticked.

Simply use the 'error message' tab to create something like: "Ensure you
type in cell A & B" and that should present you with an error dialogue box
you were after :)

Hope that was ok.

Jonathan


"Dileep Chandran" wrote:


I think, my question is not clear. I am looking for a pop up message,
like what we get if the cell has a data validation.

Anyway, thank you for all your help

The idea of giving validation is pretty good. Thanks.
But the formula is not working for me.

The formula should be like, If A1 is not blank, B1 is blank, we could
not be able enter any text in C1.

Is my question clear now?.

Thanks
Dileep

This should do as the data validation formula if you only want C1 enabled
when both A1 & B1 have data.

=AND(ISBLANK(A1)=FALSE,ISBLANK(B1)=FALSE)

--
Ian
--
"Dileep Chandran" wrote in message
oups.com...
The idea of giving validation is pretty good. Thanks.
But the formula is not working for me.

The formula should be like, If A1 is not blank, B1 is blank, we could
not be able enter any text in C1.

Is my question clear now?.

Thanks
Dileep

Thanks Ian. Its working fine.

Thank you all for the support given to sort out this issue.

-Dileep

Glad to help. Thanks for the feedback.

--
Ian
--
"Dileep Chandran" wrote in message
ups.com...
Thanks Ian. Its working fine.

Thank you all for the support given to sort out this issue.

-Dileep