If this Date Range and This Cell Value Match?

[thisishailstorm]

Hello,
I am trying to highlight a collision if the date ranges in columns B and C coincide as well as the values in column F. The collision column G should then be either red, or indicate yes or an x.
How would I express this?

Thank you!

 

[maabadi]

you want only for consecutive rows or search at the total range?

 

[maabadi]

I suppose three condition:
1. Consecutive Rows
2. Non-Consecutive Rows with show Index at Column A for 2nd match
3. Non-Consecutive Rows with "YES"

Book1
	A	B	C	D	E	F	G	H	I
1							For Consecutive	Not Consecutive
2	1	BA	BA			Not RO	No	11	YES
3	2	BA	BA			RO	No
4	3	CRE	CRE			Not RO	No	12	YES
5	4	CRE	CRE			RO	No
6	5	CS	CS			Not RO	No
7	6	CS	CS			RO	No
8	7	INTDB	TSE			RO	No
9	8	MA	MA			RO	No
10	9	MA	MA			Not RO	No
11	10	BCPSR	BCPHN			Not RO	No
12	11	BA	BA			Not RO	No	11	YES
13	12	CRE	CRE			Not RO	No	12	YES
Sheet1

Cell Formulas
Range	Formula
G2:G13	G2	=IF((B2=B3)*(C2=C3)*(F2=F3), "Yes", "No")
H2:H13	H2	=IFERROR(INDEX($A$2:$A$13,SMALL(IF((B2=$B$2:$B$13)*(C2=$C$2:$C$13)*(F2=$F$2:$F$13),ROW($B$2:$B$13)-ROW($B$2)+1),2)),"")
I2:I13	I2	=IFERROR(IF(SMALL(IF((B2=$B$2:$B$13)*(C2=$C$2:$C$13)*(F2=$F$2:$F$13),ROW($B$2:$B$13)-ROW($B$2)+1),2),"YES","NO"),"")
Press CTRL+SHIFT+ENTER to enter array formulas.