In Excel 2010, hoping to highlight all the cells in a range (about 100 cells) that match whatever's in the cell I'm currently in. All cells contain plain text (cells in the range being highlighted, and cells in the range being navigated with the cursor, and the two ranges do overlap).

Been fumbling around with variations on INDIRECT(), CELL(), ROW(), and COLUMN(), ... but no luck. I seem to get either everything always highlighted, or nothing ever highlighted.

Any help greatly appreciated!