Discussion on:

10 steps to a multi-column search in Excel

I'm not sure there would be a lot of times when I would want to use this approach over auto-filter or database lookups.

The big disadvantage I see is having to scroll through your data set to see all highlighted rows. A second point is the solution only provides a visual clue; it does not allow you to easily act upon those identified rows.