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

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