I made the color flow icing today for the first time. I dont know if i did it right, but it was really thick and it was kind of soft but not really.

That sounds about right. The more water you add, the thinner it gets. If you want it to be able to flow, add a couple of drops of water at a time and mix. It is ready when you drop a dollop of color flow into the bowl and it gets absorbed into the rest by the time you count to 10 (a slow count to 10)

My Wilton instructor told us that colorflow and royal icing should be about the consistency of toothpaste when mixed right (before thinning out to fill in an image). As pp said, we were taught the 10 second thing when we thin it out.