CF help.

[serge]

Hi,

Im looking for a CF formula that will highlight only the cells that match those 6 values from A1:A6 in the table C1:M6. Thank you.
Serge.

 

[Toadstool]

Hi Serge,

This should work for you:

Serge.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M
1	1		1	1	2	2	2	1	1	2	1	1	1
2	1		1	1	1	2	2	2	2	2	2	2	2
3	1		1	1	1	2	2	1	1	1	1	1	1
4	1		1	1	1	2	2	2	2	2	2	2	2
5	2		2	2	1	2	2	1	1	1	1	1	1
6	2		1	2	2	1	2	2	2	2	2	2	2
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:M6	Expression	=CONCATENATE($A$1,$A$2,$A$3,$A$4,$A$5,$A$6)=CONCATENATE(C$1,C$2,C$3,C$4,C$5,C$6)	text	NO

 

[serge]

Thank you so much Toadstool, It works perfect.
Serge.