P
Peter
I want to validate data between 2 variables. I put a number in cell C1 and
another number in cell C2. Then I set up the following Data Validation rule:
Whole Number
between
=C1
=C2
This validates the cell but the error message is not clear if a number is
entered outside the appropriate range. Error message:
"The value to be entered must be a whole number between =C1 and =C2."
It should display the actual numbers in C1 and C2. Has anyone else come
across this, or know a work around?
another number in cell C2. Then I set up the following Data Validation rule:
Whole Number
between
=C1
=C2
This validates the cell but the error message is not clear if a number is
entered outside the appropriate range. Error message:
"The value to be entered must be a whole number between =C1 and =C2."
It should display the actual numbers in C1 and C2. Has anyone else come
across this, or know a work around?