conditional formating

[kerm007]

Hello how can i do conditional formatting when the same character appear 4 time in a row in let say row B3 to b24
i tries different thing but what i found is only for a column
Thanks

 

[SanjayGMusafir]

Check this -

 

[SanjayGMusafir]

so it will be the same formula but green ?

For green the rule is simple

If cell contains X

Check below -

 

[SanjayGMusafir]

when the same character appear 4 time in a row

Explain it better

You want to look for a particular word that repeats in cells from B3 to B24?

 

[kerm007]

i want to highlight the 4 cell when the same character appear 4 time in a row
let say in row B3 to B24 i have a sequence of 3 time a X i want nothing but cell b7 to b10 the x appear 4 time i want the cell B10 to be colored in red
basically i have a league and i want each time a player came i put an x to the presence and at the 4 time they came in a row i will give somthing
Regards

 

[SanjayGMusafir]

same character appear 4 time in a row

Best practice would be to use a helper column which counts the continuous repetition.

Check this -

Book2
	B	C
2	Data	Helper
3	X	1
4	X	2
5	X	3
6	O	1
7	O	1
8	O	1
9	X	1
10	X	2
11	X	3
12	X	4
13	O	1
14	O	1
15	O	1
16	X	1
17	X	2
18	X	3
19	X	4
Sheet1

Cell Formulas
Range	Formula
C3:C19	C3	=IF(AND(B3="X",B3=B2),C2+1,1)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B3:C19	Expression	=OR(C6=4,C3=4)	text	NO

 

[kerm007]

ok but in column B i have all the players name and starting in C2 i have dates i put x on column like this

is it fesible ?
Thanks '

 

[SanjayGMusafir]

I would suggest you better share a sample data via XL2BB with actual scenario to understand and find a workable solution.

 

[kerm007]

ok and how i do that ?

 

[SanjayGMusafir]

ok and how i do that ?

Follow the link underneath -

Use XL2BB tool to post your sample data