Data validation help

Hi

I would like to prevent users from being enter specific values through data validation.

The current formula is “=OR(AND(E2="Reference Pressure",OR(J2<0,J2="STD")),AND(E2="Flame Transmission",J2>0))”

I would like to expand on this so that when “Reference Pressure” is selected in column E, you can either enter “STD” or a value between -20 °C to -60 ° C (Not possible to enter say -10 °C for example)

Similarly if “Flame transmission” is selected in column D you can either enter “STD” or a value between 60 °C to 220 °C


Thanks!

See the yellow banner?
Then please post a sheet as described

I think i managed it for anybody interested..

=OR(AND(E2="Reference Pressure",J2<-19,J2>=-80),(AND(E2="Reference Pressure",(EXACT(J2,"STD")))),(AND(E2="Flame Transmission",J2<221,J2>=60)),(AND(E2="Flame Transmission",(EXACT(J2,"STD")))))

now.. does anybody know how i can make it CAPS only? i.e. unable to enter "std".

The only text you should be enter in this cell is "STD"



edit: Nope not managed it. if E2 is blank i can enter whatever text i like in J2!