Exceptions to Validation Rules

[Jim Johnson]

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?

 

[Max]

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

 

[Dave Peterson]

Maybe you can just issue a warning?

Data|validation|Alert Tab.

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

 

[NHarkawat]

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]

Thanks Guys,

Your suggestions really helped out.

 

[Max]

You're welcome !
Thanks for posting back*
*better late than never <g>