Thank you. How would I repeat this conditional format for
a series of cells (D7 to D500)?
-----Original Message-----
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.
.
|