Custom data validation formula

[sdc83]

I'm trying to set a custom formula in data validation to only allow the words "clean" "residues" or also to allow any number in a specific column. I'm still quite new to excel and struggling to find the correct formula to make it work with both specific words and also numbers. I'm ready to pull my hair out because I think it should be easy but cant quite figure it out.

 

[Peter_SSs]

Welcome to the MrExcel board!

Say for D2, try

=OR(D2="clean",D2="residues",ISNUMBER(D2))

 

[sdc83]

Welcome to the MrExcel board!

Say for D2, try

=OR(D2="clean",D2="residues",ISNUMBER(D2))

Thanks for the fast reply Peter. still having trouble, sorry to be a pest. i need the data validation to be applied from cell J5 to J300 if thats possible. still cant get it to work.

 

[Peter_SSs]

applied from cell J5 to J300 if thats possible. still cant get it to work.

Remove any existing DV from that range
Select J5:J300 so that J5 is the active cell
Apply the DV custom formula =OR(J5="clean",J5="residues",ISNUMBER(J5))

 

[sdc83]

Remove any existing DV from that range
Select J5:J300 so that J5 is the active cell
Apply the DV custom formula =OR(J5="clean",J5="residues",ISNUMBER(J5))

Seems so obvious now you say it. That’s worked perfectly. Thanks very much for the help that’s brilliant.

 

[Peter_SSs]

That’s worked perfectly. Thanks very much for the help that’s brilliant.

You're welcome. Thanks for the follow-up.