A aditya Jun 1, 2009 #1 how can i make error message pop up when certain predefined mandatory cell (say C1,D1 &E1) left blank?
how can i make error message pop up when certain predefined mandatory cell (say C1,D1 &E1) left blank?
J Jacob Skaria Jun 1, 2009 #2 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
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
A aditya Jun 1, 2009 #3 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
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
J Jacob Skaria Jun 1, 2009 #4 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
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
