White balance mistake

[Rich E500]

I took a whole bunch of photos last weekend under flourescent light at a car show, on the little screen on my camera the white balance looked ok, but on the computer it looks off, with a kind of sepia hue and all the metal halide lights have a different hue to them in the rows on the ceiling.
I've tried all sorts of adjustments with CS2 and followed instructions from various websites on how to correct white balance, but I just can't get it to work. It seems to correct one thing but make it equaly as bad with something else instead.

Can anyone have a go with this pic and see if they can get it looking a little bit better and give me an idea of what I need to do?

Thanks

 

[Rich E500]

Odd, that pic is a different colour since I uploaded it to Photobucket. Here is one via my Flickr:

Full size pic - http://farm6.static.flickr.com/5291/5499241563_6184b742f9_b.jpg

Edit, this one also looks more gray since uploading, wtf? Anyway, this one had really red wheels and whitewalls, not yellow walls! And the floor around it was more of a deeper gray too.

 

[AJQS]

Well you're never going to get the lights to look the same unless you manually use a hue brush to change their colour. Persoanlly, I'd be seeting the white balance for the truck, which is way too green, temperature seems about right though.

It still seems to have a magenta cast but it's better:

An aggressive level/contrast adjustment would be great for it IMO.

 

[Triggaaar]

 

[Triggaaar]

 

[swanseamale47]

I had a quick go,the problem is there seems to be 2 different colour lights, ones a magenta the other a green-ish/cyan which make it harder, this is about as good as I can get without spending a lot of time on it.
Wayne

 

[Rich E500]

Thanks for your efforts guys, I'll have a play with them and see if I can get them a little closer to what they should be.