Debra Dalgleish Wrote:
Unchecking 'Ignore blanks' doesn't force users to enter a value in a
cell.So what's the purpose of that check box


Debra Dalgleish Wrote:
... ...to check for blank cells, or use conditional
formatting in conjunction with the data validation.
Conditional formatting is no solution since you can't enter a "IsBlank"
or equivalent criteria, only "Cell value Is" or "Formula Is". Do you
have more ;)


--
mcs51mc
------------------------------------------------------------------------
mcs51mc's Profile: http://www.excelforum.com/member.php...o&userid=28645
View this thread: http://www.excelforum.com/showthread...hreadid=482418