>Can this be done? I think I've seen that it can, but we can't seem to get it working.

The simplest way is to add Checkbox column and let user to check lines that should be selected, you may change color line based on checkbox controlsource field.