It works best on allergies as opposed to colds, but some people find it helpful even for colds. It does take some getting used to to pour (salted) water through your nose, but once you do, it really helps!
Personally, I like the Sinus Rinse system that comes with a squirt bottle. I found it easier to use than a neti pot and it gets further in there. But either will work.