We have a requirement that cells require validation, but they can also be left empty. We can use the ESC key if they start editing a cell but then decide to leave it blank. The problem is if there was already a value in the cell and they edit to cell to make it blank, if they TAB they get the validation message, if they ESC it reverts back to its original numeric value. Basically is there any way to get the validation to accept a min and max range for the cell or accept the cell being blank?
