Need Data Validation Help

[SH..What.the.What]

Hi All ... I am a code novice ... and evidently I don't follow instructions well or I seriously missed a step ... so ... I want to start from Scratch.

I have a form I created to gather information. Each cell that indicates information is required, really has to have the information entered. The information may have numbers and letters, just numbers or just letters, entry is absolutely required so .....

I have Cell E9 which requires a contract number is entered ... this contract number will have Numbers, Letters and Dashes. The next cell that will require Data is K9 and here the Type of Work Performed needs to be entered and the data to be entered would be alphabetic (but for coding purposes can be the same) I would like an Error Pop Up if the user leaves E9 blank before they can move on to K9. (Please note, eventually the user will get to C13 and the next cell requiring information will be E21)

I entered the following in Data Validation "Custom"

=IF($E9<>"","","Enter Data in K9")

The formula is allowed but the Error Alert I created isn't popping up when E9 is empty, I can continue to tab right through the document with no Error Alert.

Any help any one can give would be greatly appreciated ... I googled and binged and couldn't find the information I needed.

Thanks,
Shawn

 

[NARAYANK991]

Hi Shawn ,

For your DV in cell K9 , use the following formula :

=LEN(TRIM($E9))<>0

Ensure that the IGNORE BLANK checkbox is UNCHECKED.

Narayan