Flagging values

[SBulinski1975]

So I have been working on this for a few days and have had no success. I would like to create a condition that would flag (highlight) a cell if there are consecutive values in other cells.


Here is the information:

Gino

Yes

No

No

No

No

No

No

So I would like the conditioning to be setup that if "No" is entered 4 to 6 times consecutively, it "flags" the name cell and colors it red.


Thanks

 

[Sergius]

Is this what you need?

Book1.xlsm
	A	B	C	D	E	F	G	H
1	Gino	Yes	No	No	No	No	Yes	No
Sheet12

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1	Expression	=COUNTIF(B1:H1;"No")>4	text	NO

 

[StephenCrump]

@SBulinski1975, welcome to the Forum!

It would be helpful to know what version of Excel you're using, as the best solution may vary by version.

But this should work for you, regardless of version:

	A	B	C	D	E	F	G	H	I
1	Name	Q1	Q2	Q3	Q4	Q5	Q6	Q7	Q8
2	A	No	No			No	No		No
3	B		No	No	No	No		No
4	C	No	No	No		No	No	No
5	D	No		No	No	No	No	No
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A5	Expression	=MAX(FREQUENCY(IF(B2:I2="No",COLUMN(B2:I2)),IF(B2:I2<>"No",COLUMN(B2:I2))))>=4	text	NO

 

[SBulinski1975]

Thanks for the replies yall however, I miss understood my supervisors instructions. It is not the name but the consecutive days the need to be highlighted.

Name	1/4	1/8	1/11	1/15	1/18	1/22	1/25	1/29	2/1	2/5
Craig	No	Yes	Yes	No	No	No	No	Excused	LOA

StephenCrump, I am using Excel 2007 on my home computer and then transferring to Google Sheets so that multiple people can review it in real time.

Yalls solutions did work on 2007, thats great!!


Thanks again