Red is static non-movable. You can interact with it though.
Yellow is generally only used on weapons and shields.
Blue is usually for clutter items. Anything that can be moved.
There's also purple, which shows up on animated objects.
I've seen green and white as well, but I forget on what. I don't think whatever those are for is something Oblivion is meant to support.