Reply to Message

Off-screen rows
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.
Posted by sparent
Updated - 6th Jul