Data Validation Help

[clappl001]

Hello

Purchase order template.xlsx
	C	D	E	F
11	Operation	Size (in)
12		Wide		Height
13	Single Slide	200.00	X
14			X
15			X
16			X
17			X
18			X
19			X
20			X
21			X
22			X
Order Guide

Cells with Data Validation
Cell	Allow	Criteria
F13:F22	Whole number	between 24 and 118.11
C13:C22	List	=Sheet3!$D$2:$D$4
D13:D22	Custom	=OR(D13="",AND(NOT(ISBLANK(C13)),C13="Single Slide",D13>=24,D13<=177.19),AND(NOT(ISBLANK(C13)),C13="Double Slide",D13>=48.75,D13<=354.33),AND(NOT(ISBLANK(A1)),C13="Duo Slide",D13>=24,D13<=177.19))

I am running into an issue with the above where when I enter for example "Double Slide" into C13 and then input a value of say 200 into D13, I can then change C13 to "Single Slide" even though the value in D13 of 200 is now out of the range of the "Single Slide" category. Is there any fix for this?

Thanks

 

[KRice]

Is this problem posted twice by different users? I think I already offered a suggestion:

Data Validation Dilema

Needing a solution, a formula in data validation; =OR(D13="",AND(NOT(ISBLANK(C13)),C13="Single Slide",D13>=24,D13=48.75,D13=24,D13

www.mrexcel.com