Exceptions to Validation Rules

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Maybe you can just issue a warning?

Data|validation|Alert Tab.

You have Stop|Warning|Information options that you can choose from.
 
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)
 
You're welcome !
Thanks for posting back*
*better late than never <g>
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do i create a formula to give a workday date? 2
Validation in child form 1
Validation rule for Combo Box 0
Validation Rule 2
Validation Rules for a Control on a Form (?) 4
Macros running with Validation Rules 2
Validation Rule anomaly 6
variable in data validation 4

Back
Top