Hi -

Please suggest me how to process a column (Conditionally) with the required values only...?

For example, I'm having a column called Exam Status for which I need to get values Y/N only.

Exam Status (Y/N)
--------------------
Y


N
Pass ==> I dont like others to type other than Y / N.
Y
Y
N

Thanks In advance
-Balas

highlight the column ( lets say column "A" )
go data / validation / custom
this will allow a Y or N in the column anything else will show error

This is working fine.

But, my requirement is I need to restrict the cell values of a particular column. For a column called Exam_Status the values I need to populate should restrict to Y/N only.

Please provide your suggestion.

Thanks,
-Balas

That is exactly what grizz suggested

Select the column /range you need - say col A - selection starting in A1 - and follow the suggestion. If you use another colmun, change A to the column letter you need

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks.

Got it...!

-Balas