I agree, but that depends upon an error always resolving as False. That is
something that doesn't seem right to me, and so I prefer not to rely upon
it.

"Aladin Akyurek" wrote in message
...
Just

=MATCH($D$7,$A:$A,0)

should suffice.

Bob Phillips wrote:
Use conditional formatting with a formula of
=ISNUMBER(MATCH($D$7,$A:$A,0))

and select a colour for the format.

If that source sheet is a different sheet to D7, then you will need to
give
the cells in column A a workbook name and refer to that in the formula.