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

To make sure these fields are filled...

1. Select the range or the entire worksheet.

2. Enter the below formula in DataValidationCustom 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
ValidationError Alert....and click OK.

4. Select the cells C1,D1,E1 and clear all from EditClearAll


If this post helps click Yes
---------------
Jacob Skaria


"aditya" wrote:

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

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" wrote:

To make sure these fields are filled...

1. Select the range or the entire worksheet.

2. Enter the below formula in DataValidationCustom 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
ValidationError Alert....and click OK.

4. Select the cells C1,D1,E1 and clear all from EditClearAll


If this post helps click Yes
---------------
Jacob Skaria


"aditya" wrote:

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

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
---------------
Jacob Skaria


"aditya" wrote:

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" wrote:

To make sure these fields are filled...

1. Select the range or the entire worksheet.

2. Enter the below formula in DataValidationCustom 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
ValidationError Alert....and click OK.

4. Select the cells C1,D1,E1 and clear all from EditClearAll


If this post helps click Yes
---------------
Jacob Skaria


"aditya" wrote:

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