Conditional Formatting consecutive cells

[Venners]

I'm trying to figure out how to highlight cells where there are 3 or more consecutive occurrences of a number above 85 which would highlight in green and 3 or more consecutive occurrences of a number under 80 which would highlight in red, I imagine there'd be two different conditional formatting rules needed for them. So in the below table, cells A18, B18, C18 and D18 would all be Green as they were consecutively over 85, and E5, F5, G5 would be in red as they're under 80

Book1
	A	B	C	D	E	F	G	H
1
2				84.47	90.83	81.82	83.18
3				74.94	81.82	78.01	81.42
4				76.52	84.24	85.66	85
5					77.78	79.32	77.9
6			87.12	83.48	82.05	81.14	80.68
7						87.55	89.41
8					83.9	89.83	87.05
9					80.83	84.81	86.14
10					73.94	82.01	76.86
11						89.14	88.64
12						83.32	84.09
13						86.82	85.81
14			92.73	90		85.91	87.17
15
16							85.77
17							83.41
18	80.4	89.55	90.71	88.51	80.1	88.59	82.95
19						87.83	92.07
20						81.23	87.82
21			74.29	83.71	76.82	80.61	82.02
22						80.56	88.38
23			74.94	82.05	82.73	77.05	74.89
24					82.58	83.48	84.85
25							82.68
26							80.37
27			80.8	80.64	82.05	80.38	81.09
28						73.74	82.17
29
30
Sheet1

 

[6StringJazzer]

Two conditional formatting rules are needed. It might be possible to simplify these.

cells A18, B18, C18 and D18 would all be Green as they were consecutively over 85,

A18 is not over 85.

$scratch.xlsm
	A	B	C	D	E	F	G
1
2				84.47	90.83	81.82	83.18
3				74.94	81.82	78.01	81.42
4				76.52	84.24	85.66	85
5					77.78	79.32	77.9
6			87.12	83.48	82.05	81.14	80.68
7						87.55	89.41
8					83.9	89.83	87.05
9					80.83	84.81	86.14
10					73.94	82.01	76.86
11						89.14	88.64
12						83.32	84.09
13						86.82	85.81
14			92.73	90		85.91	87.17
15
16							85.77
17							83.41
18	80.4	89.55	90.71	88.51	80.1	88.59	82.95
19						87.83	92.07
20						81.23	87.82
21			74.29	83.71	76.82	80.61	82.02
22						80.56	88.38
23			74.94	82.05	82.73	77.05	74.89
24					82.58	83.48	84.85
25							82.68
26							80.37
27			80.8	80.64	82.05	80.38	81.09
28						73.74	82.17
Consecutive CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:G28	Expression	=OR(IFERROR(COUNTIF(OFFSET(A1,0,-2,1,3),"<80")=3,FALSE),IFERROR(COUNTIF(OFFSET(A1,0,-1,1,3),"<80")=3,FALSE),IFERROR(COUNTIF(OFFSET(A1,0,0,1,3),"<80")=3,FALSE))	text	NO
A1:G28	Expression	=OR(IFERROR(COUNTIF(OFFSET(A1,0,-2,1,3),">85")=3,FALSE),IFERROR(COUNTIF(OFFSET(A1,0,-1,1,3),">85")=3,FALSE),IFERROR(COUNTIF(OFFSET(A1,0,0,1,3),">85")=3,FALSE))	text	NO

 

[Venners]

Thanks for this, I've got it working now!