Single value data validation

How to use Data Validation VIA FORMULA (Custom) to allow only the value 1?

Why do you need a formula for this? You can use List with one item.

Hope this helps.

Pete

=[cell]=1

Regards

Originally Posted by Pete_UK

Why do you need a formula for this? You can use List with one item.

Hope this helps.

Pete

Don't want the drop down icon

Originally Posted by RaulSerg

=[cell]=1

Regards

Thanks, I was using [cell]=1, which it was taken but did not work.

Try Data validation > Custom

=A1="drgkt"