data validation challenge

H

HGood

Hi,

I'd like to set up data validation so that the only data that can be entered
into cells is twofold:
1. a number between 1980 and 2050
2. the text "Phase 2" or "Phase 3"

I know how to do #1, but is there a way to also allow the text of #2, in
place of #1?

Either one or the other.

Thanks,

Harold
 
J

JE McGimpsey

One way:

Allow: Custom
Formula:

=IF(ISNUMBER(A1),AND(A1>1980,A1<2050),OR(A1="Phase 2",A1="Phase 3"))
 
H

HGood

Thanks, that is exactly what I needed, it did the job first time round!

Harold
==================
 
Top