Microsoft Office Forums - View Single Post - Cell - Y/N

Thread: Cell - Y/N

View Single Post

Old

04-26-2012, 01:52 AM

grizz

grizz is offline

grizz uses Windows XP

Windows XP grizz uses Office 2003

grizz uses Office 2003

Office 2003

Novice

Join Date: Jan 2012

Posts: 28

grizz is on a distinguished road

Default

highlight the column ( lets say column "A" )
go data / validation / custom

Code:

=AND(OR(A1="N",A1="Y"),LEN(A1)=1)

this will allow a Y or N in the column anything else will show error

Reply With Quote