Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() 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 |