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
|