I would like to be able to click on a cell and a macro would run that would
highlight all cells in the spreadsheet that have the same value as the cell
that was just clicked. For example if cell A12 has the value "Bob" then if I
left mouse click that cell, all other cells containing the value "Bob" would
be highlighted red. If I click on the cell A13 that has the value "jill" then
all instences of Bob would be unhighlighted and all cells containing the
value Jill would be then highlighted red. I would like this marco function to
work for any cell that is clicked in the A12 to A24 range. The search area
would be A1:A10. Thanks