There are different aspects to this. One is the effect that ambient lighting is going to have as a colour cast in your image. Different light sources have different colours. In the old days (apparently) there were really only 3 light sources: Daylight/white, Tungsten/Orange and Fluorescent/green. If you were shooting indoors with normal daylight balanced film under tungsten lamps they gave the photo a nasty orange cast. If you want to see this for yourself look back through an old photo album. Fluorescent lamps turned everything green and daylight was good old reliable white. unfortunately nowadays there are so many different lamps that it’s not so simple anymore. What looks like a tungsten lamp can give a green colour cast and what looks like a fluorescent lamp can be orange. Not to mention all of the other possibilities. Here are a series of shots taken under what looked like fluorescent lamps
The left hand image is taken with the camera set to auto white balance. The middle is set to fluorescent and the right hand is tungsten. Of the three the right hand looks the most correct but the bulbs looked like fluorescent. On strobist.com David hobby recommends shooting some test shots with different settings to see which looks best and I think that’s a good idea. Of course this is only a problem if you have two light sources like tungsten and daylight for instance. One will be a different colour to the other. Another option is to remove one from the photo so you could switch off the fluorescent or tungsten or close the curtains to remove the daylight. Here is an example of mixed light sources:
To illustrate the issues I have shot this with a flash which is approximately the same colour and temperature as daylight and also two CFL lamps. The CFL lamps look much more orange than the flash. Its being able to compensate for the two that the trick. As I have said one option is to remove one light source altogether. Another option with artificial light is to change the colour of the light by adding a coloured gel. The most interesting aspect of this to me is to use it creatively.