I have a cell which I am validating with the data validation
functionality in Excel.

Tech_no, Code_List_Support, and Code_List_Technician are defined names
(the latter 2 are ranges).

The validation is that it must be a whole number with the following min
and max values:

Min =
IF(ISBLANK(Tech_No),MIN(Code_List_Support),MIN(Cod e_List_Technician))
Max =
IF(ISBLANK(Tech_No),MAX(Code_List_Support),MAX(Cod e_List_Technician))

I have the Ignore Blank Values UNCHECKED. However, when I tab over the
cell and leave the cell blank, I do not get an error message. I tried
hitting enter with the same result.

I'd like to make sure that the cell is not blank.

Any suggestions? Thanks.