I am referencing a list on anther sheet in the same book for data validation
for cells in a range; the in-cell drop downs work fine, the input is user
keyboard, recalc is auto, there are no formulas in the cells and show error
alert is checked. But I get no alert, and if I enter invalid data and then
serch for invald data, there is none. Anyone know why data not in the list
would not be recognized as invalid? (data valdiations elsewhere in the
workbook work fine). Thanks.