validated data range in a cell containing a formula
Posted by clint aird on June 19, 2001 1:17 AM
to all who wish to help
i have a cell in a spreadsheet that verifies data has been entered correctly by subtracting a value from another. i would like to have an error message appear if the value is not within the range of + or - $5. if i try and use the data-validation settings, it cannot produce an error message as this function does not work with a cell containing a formula - only if the data is entered by hand.
having it audit the data is a bit useless, as I need this as a safegaurd to prevent ignorant people (ie the boss) from putting in data (they may or may not be too lazy to perioically audit the data to check for the error)
any macros or suggestions that will check this for me?
suggestions much appreciated!