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

 

[kerm007]

ok

 

[kerm007]

Like this ?

Assidute 4 semaines DONOTUSE.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
2		Semaines	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20
3	Numbers	Names	9/7/2023	9/14/2023	9/21/2023	9/28/2023	10/5/2023	10/12/2023	10/19/2023	10/26/2023	11/2/2023	11/9/2023	11/16/2023	11/23/2023	11/30/2023	12/7/2023	12/14/2023	12/21/2023	12/28/2023	1/4/2024	1/11/2024	1/18/2024
4	1	Pierre Auger
5	2	Stephane Lapierre
6	3	Denis Hammarenger
7	4	Stephane Rousseau
8	5	Serge Lessard
9	6	Yvon Belanger
10	7H	Gerald Temblay
11	8	Sylvain Litalien
12	9	Fanny Piche
13	10H	Alex Sivret
14	11	Jasmin Bud Beauregard
15	12	Grégoire Dubé
16	13	Eric fortin
17	14	Normand Belanger
Sheet1

Cell Formulas
Range	Formula
D3:V3	D3	=C3+7

 

[SanjayGMusafir]

Yes like this. But where are the "X" that you want to check for conditional formatting?

 

[kerm007]

C4 to V4
and each row like this
D4 to V4 etc...

 

[SanjayGMusafir]

C4 to V4
and each row like this
D4 to V4 etc...

I can't help without proper sample data. Earlier you said B3:B24 which is 1 column now you are talking different.

Hope someone better than me is able to help you.

 

[kerm007]

better like this

Assidute 4 semaines DONOTUSE.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
2		Semaines	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16
3	Numbers	Names	9/7/2023	9/14/2023	9/21/2023	9/28/2023	10/5/2023	10/12/2023	10/19/2023	10/26/2023	11/2/2023	11/9/2023	11/16/2023	11/23/2023	11/30/2023	12/7/2023	12/14/2023	12/21/2023
4	1	Pierre Auger	x	x	x	x
5	2	Stephane Lapierre
6	3	Denis Hammarenger		x
7	4	Stephane Rousseau	x		x
8	5	Serge Lessard
9	6	Yvon Belanger	x	x		x
10	7H	Gerald Temblay
11	8	Sylvain Litalien	x
12	9	Fanny Piche			x
13	10H	Alex Sivret	x			x
14	11	Jasmin Bud Beauregard		x	x
15	12	Grégoire Dubé
16	13	Eric fortin
Sheet1

Cell Formulas
Range	Formula
D3:R3	D3	=C3+7

TY

 

[SanjayGMusafir]

Check this -

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2		Semaines	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16
3	Numbers	Names	7/9/23	7/16/23	7/23/23	7/30/23	8/6/23	8/13/23	8/20/23	8/27/23	9/3/23	9/10/23	9/17/23	9/24/23	10/1/23	10/8/23	10/15/23	10/22/23
4	1	Pierre Auger	x	x	x	x
5	2	Stephane Lapierre
6	3	Denis Hammarenger		x
7	4	Stephane Rousseau	x		x
8	5	Serge Lessard
9	6	Yvon Belanger	x	x		x
10	7H	Gerald Temblay
11	8	Sylvain Litalien	x
12	9	Fanny Piche			x
13	10H	Alex Sivret	x			x
14	11	Jasmin Bud Beauregard		x	x
15	12	Grégoire Dubé
16	13	Eric fortin
Sheet1

Cell Formulas
Range	Formula
D3:R3	D3	=C3+7

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C4:R16	Expression	=OR(AND(C4="x",B4="x",A4="X",XFD4="x"),AND(C4="x",D4="x",E4="x",F4="x"),AND(C4="x",B4="x",D4="x",E4="x"),AND(C4="x",B4="x",A4="X",D4="x"))	text	NO
C4:R16	Cell Value	contains "x"	text	NO

 

[kerm007]

perfect where do i enter this ?
sorry not sure i enter the value

 

[SanjayGMusafir]

I was thinking of making formula short so got this -

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2		Semaines	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16
3	Numbers	Names	7/9/23	7/16/23	7/23/23	7/30/23	8/6/23	8/13/23	8/20/23	8/27/23	9/3/23	9/10/23	9/17/23	9/24/23	10/1/23	10/8/23	10/15/23	10/22/23
4	1	Pierre Auger	x	x	x	x
5	2	Stephane Lapierre
6	3	Denis Hammarenger		x
7	4	Stephane Rousseau	x		x
8	5	Serge Lessard
9	6	Yvon Belanger	x	x		x
10	7H	Gerald Temblay
11	8	Sylvain Litalien	x
12	9	Fanny Piche			x
13	10H	Alex Sivret	x			x
14	11	Jasmin Bud Beauregard		x	x
15	12	Grégoire Dubé
16	13	Eric fortin
Sheet1

Cell Formulas
Range	Formula
D3:R3	D3	=C3+7

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C4:R16	Expression	=OR(AND(C4:XFD4="x"),AND(C4:F4="x"),AND(B4:E4="x"),AND(A4:D4="x"))	text	NO
C4:R16	Cell Value	contains "x"	text	NO

 

[SanjayGMusafir]

perfect where do i enter this ?
sorry not sure i enter the value

Select cells C4:R16 and then choose conditional formatting

Then choose Classic

then Use formula and paste there

Hope I'm giving correct steps for Excel 365