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?