Highlight Like Values

B

Brandon G.

lets say I have the following info

A1 A2
1 5
2 6
3 7
4 8
5 9

I want to tell excel to highlight any numbers in column A2 that are
repeats from column A1...in this case only 5 would be highlighted?

Any thoughts?

Brandon
 
T

Teethless mama

Conditional Formatting:

=COUNTIF($A$1:$A$5,$B1)>0

format any color you like
 
Top