Here is a tutorial about realistically coloring light sources using color temperature. Every light source has a specific temperature in Kelvin.
Cinema4d 9.5 has a nifty little node to help us convert these values to hues and it is called...Color Temperature as expected.
It is very simple and needs no explanation at all. Just enter a value and it gives you a color. Connect the output to the color of your lights and you will get the results you need.

Follow up:

To make things more useful I copied a part of a color temperature chart so you can lookup the values here (thanks to: http://www.3drender.com/glossary/colortemp.htm )
1700-1800 Match Flame
1850-1930 Candle Flame
2000-3000 Sunset and Sunrise
2500-2900 Tungsten bulb
3200-3500 Quarts light
3200-7500 Fluorescent light
5000-5400 Direct Sun at noon
5500-6500 Daylight
6000-7500 Sky overcast
7000-8000 Outdoor shade areas
8000-10000 Sky partly clouded

Values for common light-bulbs are provided by most manufacturers.
Interior architects are commonly confronted with light temperature issues and could find this xpresso node quite useful.

Here is a .gif that gives a general idea of what happens, sorry for the colors it is a gif.

I have posted more info in the comments of this subject...

comments closed due to a lot of spam here, probably some words in the text trigger spam!