Validation Rules

I don't believe you can have that combination in Data Validation...

But possibly you can use comboxes for the drop downs with cells behind each combobox as a cell link and then use Data Validation only for the formula check.

Originally Posted by stoney1977

Is there a way to have 2 validations rules for a group of cells.

I would like Row 12 I to Z to only be aloude X in so I would use the list validation. I would then like to use a custom validation of
=COUNTIF($I$12:$Z$12,I12)=1 so you can only put X in 1 cell in range I12 to Z12

Is there a way this con be done.

I would like it so you had a pull down menu with X as the only option.

Thanks

You can apply only one validation in a cell or range of cells.
Try the following formula for your purpose.

=AND(I12="X",COUNTIF($I$12:$Z$12,I12)=1)
It will allow once and only "X" to be entered in the range.

Does this work?