I recently took some photos under fluorescent light after setting the white balance on my D3100 to a preset using a grey card. The skin tones in the resulting photo were fine but a garment that is a greeny-blue colour (officially teal) came out looking bright blue in the pictures.
Whilst tweaking the photo using View NX2 I found that using the fluorescent white balance setting gave the correct garment colour but then the skin tones were a nasty yellow tint.
Is there anything that I could have done differently to get the correct colour rendition throughout the photo or have I exceeded the ability of the camera's technology to handle the lighting conditions?
Is the answer to use a different light source (e.g. flash or daylight studio type lights) or is there some other answer? Would a more expensive camera (e.g. D7100) have been able to cope?