Validation problem.

  • Thread starter Thread starter Petter
  • Start date Start date
P

Petter

Lets make this very simple. I have two cells. Lets call them A1 and B1. I
want the cells to be blank or contain just "X". Anything else should not be
allowed. This i can solve by making a validation rule.I have solved this just
by makeing a list that just contain "x", so you get a dropdown box with just
x in it.

But both cells cant contain "X". This can i allsow solve by makeing a
validation rule.
Here i just added =A1="" in the validation. And offcourse i can add =B1=""
in the other valiation cell.

The problem is that i cant solve both. Need help with this one. Plz.

I dont want to use buttons..cuz this will apply to over 1000 cells.
 
Select A1 and B1. Apply this formula in Data Validation:
=(COUNTIF($A$1:$B$1,"="&"X")<2)
 
Thx, but this not solve the problem with the first issue. The user can still
put anything want they into the cell. This should only be restricted to
either blank " " or "x".
 
My apologies. Try this formula instead:
=AND(OR(A1="",A1="X"),(COUNTIF($A$1:$B$1,"="&"X")<2))
(The first two cell references are meant to be relative.)
 
Back
Top