Conditional Formatting to find matching cells

[JinTHR]

Hi everyone,

I am having an issue using conditional formatting. I am trying to find cell values in one column that match cell values in a second column. once found the matching value is highlighted
In the example; 1 and 2 in the first column would become highlighted.

A B
1 0
2 1
3 3
4

Thanks everyone,
Jin K

 

[oldbrewer]

			red	1	7
				2	1
			red	3	4
					3
			I painted cells red if they occurred in second column
			cond format is	in cell D1		and format painted down
			formula
			=MATCH(E1,$F$1:$F$4,0)>0

<colgroup><col span="11"></colgroup><tbody>
</tbody>

 

[JinTHR]

1

 

[JinTHR]

Oldbrewer,
Worked beautifully! Just what I needed.
Thanks for the help!

Jin

 

[oldbrewer]

glad this 70 year old brain was able to help...