Hi,
Yes, it's possible to have more than one rule. Let me know what it is you
actually need, and I'll try to help you acheive it.
Regards - Dave.
> Date: Fri, 27 Aug 2010 07:53:14 -0700
> Subject: Re: $$Excel-Macros$$ Validation rule and 'X'
> From: janes...
Hi Dave,
The first solution was exactly what I needed. Works great. Now, is is
possible to have more than one validation rule per cell, perhaps by
creating an array in the Formula box under Validation / Settings?
Hane
--
--
Hi,
First of all, you can't use Data Validation after the data is entered. You may
apply the validation, but it won't react to invalid data. It only responds to
data entered after the validation rule is in place. If you want to be alerted
to invalid data that is already present, you'd probably