Data validation for specific text and numbers

Hi All,

I wish to have data validation to allow only text & number. I would only want 1, 0, OUTSOURCE. This worksheet also have conditional formatting where it marks 0=X, 1=√

Please find attachment.

Thank-You very much

On the Settings tab of the Data Validation dialogue box you should choose List in the Allow box and then type this in the Source box:

0,1,OUTSOURCE

You can choose whether you want an In-cell drop-down (or not).

Hope this helps.

Pete

Hi Pete,

I never thought of just to have a dropdown list instead. Too much focus on formula .
Your input taken.

Will just close this thread mark to SOLVED.

Thank-You very much

Glad to help, and thanks for feeding back. It's very easy to overlook the simple way to do things.

Pete