Hi Everyone!

Here's what I am trying to do:

I would like to have all cells containing a certain value, to become highlighted (or distinguished), when ANY cell with said value is selected.
So for example:

Clicking any cell containing "apples" would cause all cells containing "apples" to become highlighted or distinguished.
I don't want to have to search for, or use conditional formatting every time.


Thanks for the help and looking forward to all the great info around here.

Robert