data validation - more than one in same cell?
You get one message.
But can't you just word it nicely.
Please enter a value greater than or equal to 3,000 but less than 1,000,000.
KLAOI wrote:
I have set up data validation to ensure number is = or 3,000. Otherwise an
error box shows up with a message. However, I want to have another error if
the number is = or 1,000,000 with a different message. Is this possible?
Thanks.
--
Dave Peterson
|