Please help me to find formula,trying from 2 months now

[foreveras]

I want to find and highlight values from High column which are 10 times greater than low value but both these high and low values should be of same expiry date,same strike price , same option type...and if that criteria meets..then need to add 1 more criteria that high values date should be greater than that low value

MARKET DATA.xlsx
	A	B	C	D	E	F
1	EXPIRY_Date	STRIKE_PRICE	OPTION_TYPE	HIGH	LOW	DATE
2	44924	2150	CE	250	0	44896
3	44925	2200	PE	218.2	0.7	44896
4	44926	3200	PE	190.7	0	44896
5	44927	1200	CE	164.8	1.4	44897
6	44924	2150	PE	141	0	44897
7	44925	2200	PE	119.3	0	44897
8	44925	3200	CE	100.5	0	44897
9	44926	1200	CE	84.5	1.5	44897
10	44927	3200	CE	70.85	0	44898
11	44924	1200	PE	63.75	2	44898
12	44925	2150	PE	48.7	0	44898
13	44926	2200	CE	40.2	0.95	44898
14	44927	2150	PE	33.35	0	44898
15	44924	2200	CE	27.7	3.8	44898
16	44927	3200	PE	23	4.95	44898
17	44924	1200	PE	19.1	4.7	44898
18	44925	3200	CE	15.85	7.25	44899
19	44925	3200	CE	13	6.25	44899
20	44926	1200	PE	2.85	7.45	44899
21	44924	2150	PE	0	9	44899
22	44925	2200	CE	1.9	10.95	44899
23	44926	2150	PE	0	13.4	44899
24	44927	2200	CE	0	16.75	44899
25	44924	2200	PE	0	20.7	44899
26	44925	3200	CE	1.5	26	44900
27	44927	1200	CE	0	32.5	44900
28	44924	3200	PE	2.7	2.95	44900
29	44925	3200	PE	0	0	44900
30	44925	1200	PE	3.15	1.35	44900
31	44926	3200	CE	0	0	44900
32	44927	1200	PE	5.1	0	44901
33	44924	2150	CE	4.95	0	44901
34	44925	2200	PE	6.35	1.55	44901
35	44926	2150	PE	7.25	0	44901
Sheet2

 

[Fluff]

Duplicate to: Need to find and highlight values from high column which are greater than 10 times low value but on same expiry date,same strike price,same option typ

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.