I'm not sure if you want an effect to make your logo glow and have it play across the words or whether you want some sort of logo inthe dark which is revealed by a sort fo spotlight playing across it.
Either can be done. But the first sound suspicously like Trapcode Shine to me. Pop across to www.trapcode.com and play with the demo. It's good stuff.