Data Validation--drop down list AND related cells

[e_nnm_m]

Hello,

I have a spreadsheet that has been converted to a real table that runs a database. I have one column that chooses inputs based on a list on the input sheet. That works perfectly. But I would also like to add a condition to it, that if the column next to is ISBLANK then the user gets an error message directing them to fill out the blank cell with a date.

How do I do this?

Thanks,

-EM

 

[awoohaw]

Do you mean column or cell in the adjacent column?

 

[awoohaw]

Is this something can can work for you?:

Book1
	A	B	C	D	E
1	ListA	ListB		Selection
2	RRQ	LKD		MXS	Update List B
3	EIM				^^Can add conditional formatting to this as well.
4	JZF	AIM
5	FXA	FQE
6	MXS
7	VLI	BPY
e_nnm_m

Cell Formulas
Range	Formula
E2	E2	=IF(ISBLANK(INDEX($B$2:$B$7,MATCH(D2,$A$2:$A$7,0))),"Update List B","")

Cells with Data Validation
Cell	Allow	Criteria
D2	List	=$A$2:$A$7