Which files are in only multiple collections (tagging system)

In the Metadata Panel.

They work on all file types, the same as labels, as long as it's an NTFS drive. (For non-NTFS, they'll only work on some types.)

See How to assign more than 1 label for a file? - #2 by Leo

But using status icons for this would be much easier, as I suggested. You don't need to change anything if you use those.