Visible light from our Sun is a continuous spectrum from about 400 to 700 nm wavelength and we all remember the ROYGBIV mnemonic for the rainbow. Our eyes see red, blue and green light and when these are combined, eg., red + green, we see yellow light. Red + blue + green gives us white light. This is represented in my color wheel and can be helpful when are dealing with light and not pigments, to keep things simple.
So, the problem for photographers comes when instead of a continuos line spectrum source we are faced with shooting under one of the very prevalent sources in our world such as mercury vapor lamps, sodium vapor lamps, or fluorescent lights. These produce a wide variety of colors and they are missing some of the basic colors which creates a nightmare in the post processing attempting to reproduce what our brain tells us is there.
The question for this thread is.....How do the members here handle the struggle in their post processing of shots taken under difficult shooting conditions?
And here is one I took which has my son and daughter-in-law leaving for their honeymoon and the mixed light sources included mercury vapor, sodium vapor and florescent lamps.