View Single Post
  #1   Report Post  
luxbelle
 
Posts: n/a
Default Compare cells/columns and highlight matching text strings


Hello guys,

As the thread title reads, I need to compare text strings between two
cells/columns, and highlight those that match between them.

Example:
--------------------------------
A1:
VW, GM, CHRYSLER, VOLVO, FORD

B1:
FORD, GM, MITSUBISHI, NISSAN
--------------------------------

The idea is that FORD and GM be highlighted in A1, since the
conditional formatting would find those text strings in B1. Note that
the strings in A1 and B1 will always be different, varying by row.


Thanks for reading and hope you can help me with this!


--
luxbelle