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