Exceptions to Validation Rules
 

Is there a way to create a validation rule that is used 90% of the time and
also to specify an exception for the other 10%? If I had a field that was
intended to display a date and set up my validation for the date, could I
then create an exception that would allow me to type "tbd" for those dates
that have yet to be determined?

One way might be to just exploit the DV "weakness"?

Type into an adjacent cell: tbd

Copy the cell, and do a
Paste special Values OK
on the cell with the data validation

--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"Jim Johnson" wrote in message
...
Is there a way to create a validation rule that is used 90% of the time
and
also to specify an exception for the other 10%? If I had a field that was
intended to display a date and set up my validation for the date, could I
then create an exception that would allow me to type "tbd" for those dates
that have yet to be determined?

Maybe you can just issue a warning?

Data|validation|Alert Tab.

You have Stop|Warning|Information options that you can choose from.


Jim Johnson wrote:

Is there a way to create a validation rule that is used 90% of the time and
also to specify an exception for the other 10%? If I had a field that was
intended to display a date and set up my validation for the date, could I
then create an exception that would allow me to type "tbd" for those dates
that have yet to be determined?

--

Dave Peterson

go to DataValidation and select custom and type the following formula:-

=OR(AND(C3$G$1,C3<$G$2),C3="tbd")
where cells G1 and G2 house the dates (may be the upper and lower limit)

"Jim Johnson" wrote in message
...
Is there a way to create a validation rule that is used 90% of the time
and
also to specify an exception for the other 10%? If I had a field that was
intended to display a date and set up my validation for the date, could I
then create an exception that would allow me to type "tbd" for those dates
that have yet to be determined?

Thanks Guys,

Your suggestions really helped out.

"Jim Johnson" wrote:

Is there a way to create a validation rule that is used 90% of the time and
also to specify an exception for the other 10%? If I had a field that was
intended to display a date and set up my validation for the date, could I
then create an exception that would allow me to type "tbd" for those dates
that have yet to be determined?

You're welcome !
Thanks for posting back*
*better late than never <g
--
Rgds
Max
xl 97
---
Please respond in thread
xdemechanik <atyahoo<dotcom
----
"Jim Johnson" wrote in message
...
Thanks Guys,

Your suggestions really helped out.