Warning message if one column contains any text and another column is blank

[Dileep Chandran]

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

 

[Ian]

Hi DC

One option is to set a conditional format in C1.

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

 

[Guest]

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

 

[Bernard Liengme]

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?

 

[Dileep Chandran]

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

 

[Dileep Chandran]

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

 

[Bernard Liengme]

Post the question to the Excel programming newsgroup

 

[Guest]

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

 

[Guest]

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

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]

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

 

[Ian]

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)

 

[Dileep Chandran]

Thanks Ian. Its working fine.

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

-Dileep

 

[Ian]

Glad to help. Thanks for the feedback.