Conditional Formatting Using VB

B

Bill Phillips

I need to check the value of a cell against another
worksheet. If a matching value exists in both sheets then
I apply the new format (I would use a vlookup
functionality as the sheet I am comparing to has the data
in a single column). If a match does not exist, then I
leave the format the same. I could not achieve this using
the conditional formatting. Any ideas would be greatly
appreciated.
 
B

Bob Phillips

Bill,

Select the cells on sheet one, and apply conditional formatting with a
formula of

=NOT(ISNA(MATCH(A1,myRange,0)))

where myRange is a range name for the cells on the other sheet. Format to
suit.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Top