error pop up

[aditya]

how can i make error message pop up when certain predefined mandatory cell
(say C1,D1 &E1) left blank?

 

[Jacob Skaria]

To make sure these fields are filled...

1. Select the range or the entire worksheet.

2. Enter the below formula in Data>Validation>Custom and uncheck Ignore blank
=AND($C$1<>"",$D$1<>"",$E$1<>"")

3. Enter an error message say "Cells C1,D1 and E1 are Mandatory" in Data
Validation>Error Alert....and click OK.

4. Select the cells C1,D1,E1 and clear all from Edit>Clear>All


If this post helps click Yes

 

[aditya]

hi jacob,
it's helpful but i need further help

(1)error message should pop up while i cross cell C1/D1/E1 without filling
it.
right now its showing even if i am at cell A1

(2) If i fill C1 but left blank D1 & E1 message should only be for D1 &E1

 

[Jacob Skaria]

On your two points

1. In step 4 select the range (cells/columns) in which you dont need the
validation.

2. Customised messages will be possible only through a macro..With data
validation; one validation condition can only go with 1 error message.

PS: It is always helpful if you can elaborate your issue/requirement in the
first post itself...

If this post helps click Yes