White balance and colour rendition
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?
The relevant technical details are:
Nikkor AF-S DX 35mm 1.8G lens
f/2, ISO400, 1/50s, aperture priority, spot metering
I'd be very grateful for any help!