On Thu, 6 Jun 2013 18:47:13 +0100, dunndealpr wrote:

it just seems like find and replace should have worked regardless
though. that vexed me to no end.

It worked fine for me with Excel 2007. Of course, it only highlights the cell, not the entire row.