Honestly, I've had the light green after taking a vitamin supplement that I did not need. You can get red by drinking a lot of beet juice (the juice in the jar of sliced beets), but if you haven't done that red is very bad.
When I was in high school there was a kid who died of spinal meningitis. The school district distributed preventive medicine to all students. It turned my pee super orange. And from what I heard it turned guys' pee red!