Our brains, not our eyes, automatically adjust to changes in the color temperature of your video scene. Your camera will see the yellowish light, but your brain automatically adjusts this hue.
Our eyes see the warm yellowish lighting, but our brain automatically adjusts so that the colors appear normal to us. If we walk into a kitchen with fluorescent lighting, our brains will automatically adjust to the bluish light.
Recently manufactured video cameras will automatically adjust to different color situations. If you are outside, it will compensate for the bluish light. If it is inside, it will offset the orange tinted light. Older camcorders require you to do a manual adjustment.
If you have a newer camcorder, it will make these settings for you. You can improve your results by manually setting the color balance if you have one of the more advanced camcorders.
What do you do for a living? You carry a white card with you. When under new lighting conditions, simply fill the view with the white card and hit the color balance button. The camera will take a reading of the ambient conditions and generate video with the proper light balance. You must remember to do this each time you move to a different light situation.
What do you do if you are in a mixed light situation? I don’t have a good solution for this.
Here is a familiar scenario to consider. You are making videos in the late afternoon in the living room. Table lamps have incandescent bulbs that provide most of the lighting. There is a large window that lets in copious amounts of evening light. That light is bluish in color. The lights of incandescent lamps is orange. Your camcorder has to adjust to one of these light sources or the other, but it cannot adjust to both. Your video will be out of balance and you will see that it is too bluish or too orange. It won’t be perfect.
Here is a good article you can read at http://VideoProductionTips.com on white balance and color temperature in video production. Lorraine does a great job of explaining color temperature and how to improve videos of it by manually setting your white balance.
Remember, if you manually set the color balance, you will need to set it every time the lighting location changes. For you who are less particular, just leave it on auto white balance and you should be fine.