Scenario is a workbook with two sheets. I need a way for cells on sheet 2 to search sheet 1 and highlight themselves if they find any text on sheet 1 that matches.
sheet2!a2 with value of
sheet1. It finds
apple somewhere on
sheet1 and now
sheet2!a2 is highlighted green. Keep in mind,
apple may only be part of the cells in
Running excel 2012. Any ideas?
The problem with a conditional format that I can setup, even using the countif function, is that the cells have to be completely equal. Meaning if i use the above example. If the cell on sheet2 says "apple" but the cell on sheet1 says"apple-1" the conditional formatting will not work.
How can I adjust the formula to look for the same text within the cell and highlight and not actually look for a exact matching cell?