Minecraft wiki entry for Command_Block, associated text: "Impulse" command blocks are orange. They execute once every time they are activated.
"Chain" command blocks are green. They execute once every time they are triggered if they have been activated.
"Repeat" command blocks are purple. They execute their commands once every one game tick (or more‌[BE only]) as long as they are activated.