Cell Formatting with Text Data

[SBulinski1975]

Hey Yall,
I am needing assistance with cell formatting. The sheet that I am working on is insanely large (100 Rows by 85 Columns) so here is a small portion of it.

The formatting has to occur when the word "No" is consecutive 4 times, like in E2 to H2. All it has to do is color fill the cell to red.

I have to use Google Sheets due to the group I am in, there will be one one person to alter the sheet other than myself.

A​	B​	C​	D​	E​	F​	G​	H​	I​	J​
Name	1/4​	1/8​	1/11​	1/15​	1/18​	1/22​	1/25​	1/29​	2/1​
Catch	No​	Yes​	Yes​	No​	No​	No​	No​	Excused​	LOA​

Thank You

 

[DanteAmor]

Check if this works for you:

Libro1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Name	1/4	1/8	1/11	1/15	1/18	1/22	1/25	1/29	1/4	1/8	1/11	1/15
2	Catch	No	Yes	Yes	No	No	No	No	Excused	LOA	No	Yes	Yes
3	Catch	No	No	No	No	Yes	No	No	No	No	No	Yes	Yes
4	Catch	No	Yes	No	No	Yes	No	No	Yes	No	No	No	No
Hoja1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:CH100	Expression	=OR(COUNTIF(OFFSET(B2,0,0,1,4),"No")=4,COUNTIF(OFFSET(B2,0,-1,1,4),"No")=4,IFERROR(COUNTIF(OFFSET(B2,0,-2,1,4),"No")=4,0),IFERROR(COUNTIF(OFFSET(B2,0,-3,1,4),"No")=4,0))	text	NO

 

[SBulinski1975]

Check if this works for you:

Libro1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	Name	1/4	1/8	1/11	1/15	1/18	1/22	1/25	1/29	1/4	1/8	1/11	1/15
2	Catch	No	Yes	Yes	No	No	No	No	Excused	LOA	No	Yes	Yes
3	Catch	No	No	No	No	Yes	No	No	No	No	No	Yes	Yes
4	Catch	No	Yes	No	No	Yes	No	No	Yes	No	No	No	No
Hoja1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:CH100	Expression	=OR(COUNTIF(OFFSET(B2,0,0,1,4),"No")=4,COUNTIF(OFFSET(B2,0,-1,1,4),"No")=4,IFERROR(COUNTIF(OFFSET(B2,0,-2,1,4),"No")=4,0),IFERROR(COUNTIF(OFFSET(B2,0,-3,1,4),"No")=4,0))	text	NO

This works perfectly!!!!! THANK YOU SO MUCH!!!!!!