Highlight matching cells in 2 columns

[Adamp1027]

I have a list of numbers in A3:A400, I have a number in cell B1. The number in cell B1 changes. When B1 changes, I want the cell in column A that matches to be highlighted. My current formula is: =ISERROR(MATCH(B1,$A3:$A400,0))=FALSE

However, the only cell that gets highlighted when a match is found is A3 (even if the match is A20)

What am I missing?


screenshot.jpg

[JohnTopley]

Try

=A3=MATCH($B$1,$A$3:$A$400,0)

DoH! of course ... MATCH unneceesary!!!

see Etaf

[etaf]

if you select A3 to the end of the range

and in conditional formatting formula

=A3 = $B$1

and select the formatting

now as the conditional moves down the list and tests A3, A4 , A5 etc
it will not move B1 down as the $ fixes it
so

A3 = $B$1 - if true highlights, if False stays clear
A4 = $B$1 - if true highlights, if False stays clear
A5 = $B$1 - if true highlights, if False stays clear

etc

[Adamp1027]

Genius!! Thank you both for the replies.

[etaf]

you are welcome, thanks for the rep