How does colorised texture work?

A search of the developer categories on this subject:

The answer I like best comes from Andreas: