Multiple Data Validation Checks

[TAPS_MikeDion]

Sorry all, I haven't been able to find a solution to this so I'm throwing it out there in hopes someone might be able to help. It seems pretty simple and straightforward, but I can't seem to get it to work.

1. I'm already using Data Validation to warn the user if they attempt to enter data (i.e. hours) into a cell in column I if column J in the same row contains an X.
2. I would like to add another Data Validation to warn the user if they attempt to put an X in column C if column J in the same row contains an X.
3. After highlighting the cells I was going to use the Data Validation for and I click on Data Validation, it says "The selection contains more than one type of validation."

I'm only using the Data Validation mentioned in #1, but I don't know if you can use Data Validation for more than one instance.

Thanks for any help given!

 

[richh]

You should have a data validation in Column C and another in Column I. Make separate ones, both being a Custom Formula of =$J2="X"

 

[Toadstool]

Hi TAPS_MikeDion,

You must already have some Data Validation in column C.

TAPS_MikeDion.xlsx
	C	D				H	I	J
1	Entry 2						Entry 1	Data
2	Cat						x
3	Dog							X
4	XX							X
5							2
6							Dog
7							Cat
8	2							X
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
I2:I8	Custom	=J2<>"X"
C2:C8	Custom	=NOT(AND(J2="X",C2="X"))

 

[TAPS_MikeDion]

Thank you both for the help, but I got it this morning. Part of the problem was that I had not used Data Validation in a long time and I was actually highlighting the entire area as though I was creating a conditional format, instead of only highlighting column C.

I Forgot to mention that the rows start at 5, not 2, but that was an easy correction.

Anyway, I simply used =$J5<>"x" as the custom formula and the Data Validation worked perfectly.

Thanks again for trying to help me out!