Conditional formatting Highlighting cell sequences in Rows

[babybrands]

Hello

I want to highlight when a number of cells are together in a sequence that represent a pattern I am looking far

Assuming each letter is a cell in a ROW in the entire sheet.

A B C D A B C D A A A A B B B A B C D F A D F C C

I would like to identify "A and B and C and D and F" in sequence using highlight and conditional formatting.

Rather than trying to find the pattern in a huge Spreadsheet manually it would be easy to identify it by conditional formatting..

I have the Latest Office 365 version of excel.

Any help would be appreciated.

 

[DanteAmor]

Hi and welcome to MrExcel!

It would be 5 rules.
Try this:

varios 16nov2022.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	A	B	C	D	A	B	C	D	A	A	A	A	B	B	B	A	B	C	D	F	A	D	F	C	C	C	A	B	C	A	B	C
2	A	B	C	A	B	C	D	A	B	C	D	A	A	A	A	B	B	B	A	B	C	D	F	A	D	F	C	C	C	A	B	C
3	A	B	C	A	B	A	B	C	B	C	D	A	B	C	D	A	A	A	A	B	B	B	A	B	C	D	F	A	D	F	C	C
4	A	B	C	D	F	B	C	D	A	A	B	C	A	B	C	D	F	C	D	F	A	D	F	C	C	A	B	C	A	B	C	A
5	A	B	C	A	F	C	D	A	B	A	B	C	D	F	A	B	C	D	A	B	D	D	B	C	D	F	C	C	C	A	B	C
Hoja1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A1:AF5	Expression	=A1&B1&C1&D1&E1="ABCDF"	text	NO
A1:AF5	Expression	=OFFSET(A1,,-1)&A1&B1&C1&D1="ABCDF"	text	NO
A1:AF5	Expression	=OFFSET(A1,,-2)&OFFSET(A1,,-1)&A1&B1&C1="ABCDF"	text	NO
A1:AF5	Expression	=OFFSET(A1,,-3)&OFFSET(A1,,-2)&OFFSET(A1,,-1)&A1&B1="ABCDF"	text	NO
A1:AF5	Expression	=OFFSET(A1,,-4)&OFFSET(A1,,-3)&OFFSET(A1,,-2)&OFFSET(A1,,-1)&A1="ABCDF"	text	NO