Conditional Formatting Using VB

  • Thread starter Thread starter Bill Phillips
  • Start date Start date
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.
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Highlighting duplicates 0
Conditional Formatting with VBA 4
A Huge Conditional Format Challenge.... 2
Conditional formatting not working with AND 2
Conditional Format / VLookup 5
Excel VBA 1
Conditional Formatting 1
Conditional Formatting and VBA 4

Back
Top