I have a sheet that I would like to highlight cells that are equal to any of the values listed in range of cells on another sheet. How do I do this?
Sheet 1 contains values I want to highlight in green any cell that equals any value in Row A of sheet 2.
For example, column A is
Apples Oranges Peaches
I want to highlight any cell on sheet 1 that equals