It may be easier to say '1' for yes and '0' for no. That way you can
have a simple formula:
=IF(SUM(A2:D2)<1, "Error", "OK")
where columns A-D are your 4 columns

FunkySquid

cwignall wrote:
hi

i have a spreadsheet that has columns to indicate the outcome of
certain accounts at work.

for example:

Not proceeding
Gone Elsewhere
Changed Mind
Going Ahead

etc.

i need to make it so that you can only enter 'y' in of of them...if you
enter it in another it will flag it up or not let you?

can anyone help?


--
cwignall
------------------------------------------------------------------------
cwignall's Profile: http://www.excelforum.com/member.php...o&userid=36880
View this thread: http://www.excelforum.com/showthread...hreadid=565949