Sorry I didn't explain my question very well. What I really need is this.

If C8 = "x" then C9:C12 must be null

or if C9 = "x" then C8, C10:C12 must be null

or if C10 = "x" then C8:C9, C12 must be null
etc.

I have 4 cells and only 1 can contain an "X". I also need to an have error
message pop up to say "only 1 selection allowed"

Thanks

"Mike H" wrote:

Hi,

Fir text responses try

=COUNTA(A1:D1)1

or numeric

=COUNT(A1:D1)1

Mike

"BethO" wrote:

I would like to allow only 1 response in one of four cells. What formula
would I use to check if other cells are null?