color cells if they equal to other cells

[excelNewbie22]

hi!
how to color a14:f20 cells if they equal to/contain the cells in a13:f13 ?

test.xlsm
	A	B	C	D	E	F
13	1	2	3	4	5	6
14	1	2	3	22	27	32
15	2	3	16	31	32	33
16	2	6	17	20	32	36
17	4	12	20	21	30	40
18	3	12	18	31	35	41
19	1	3	19	32	36	42
20	4	5	18	35	38	44
test

 

[etaf]

how about
=countif($A$13:$F$13,A14)>0
in conditional formatting

Book6
	A	B	C	D	E	F
12
13	1	2	3	4	5	6
14	1	2	3	22	27	32
15	2	3	16	31	32	33
16	2	6	17	20	32	36
17	4	12	20	21	30	40
18	3	12	18	31	35	41
19	1	3	19	32	36	42
20	4	5	18	35	38	44
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A14:F20	Expression	=COUNTIF($A$13:$F$13,A14)>0	text	NO

for 2007, 2010 , 2013 , 2016 , 2019 or 365 Subscription excel version
Conditional Formatting

Highlight applicable range >>
A14:F20 - Change, reduce or extend the rows to meet your data range of rows

Home Tab >> Styles >> Conditional Formatting
New Rule >> Use a formula to determine which cells to format
Edit the Rule Description: Format values where this formula is true:
=countif($A$13:$F$13,A14)>0

Format [Number, Font, Border, Fill]
choose the format you would like to apply when the condition is true
OK >> OK

 

[excelNewbie22]

thank you etaf !!

 

[etaf]

you are welcome