Validator Extension
From Apache OpenOffice Wiki
Validator
Validator is an OpenOffice.org Calc extension that validates cells based on selected rules.
http://extensions.services.openoffice.org/en/project/validator
Calc: Tools → Detective → Validator