I am trying to change the color of a cell in a worksheet when the same text appears in a different worksheet.
For example
Sheet 1
Column A Row 1 = "Apple"
How can I make that cell change colors when "Apple" appears anywhere in
Sheet 2?
Thank you in advance.
Bookmarks