I am not sure if this is a technique issue or an editing issue so I decided to ask this here.
I took this photo yesterday for a client and I can't quite seem to get the white balance right hope you can help me figure out how I can fix this in the future.

You can see here the camera is facing away from a full glass exterior wall and there is a skylight up above. Most of the light is natural here. I set my white balance in camera using a gray card, I took a test shot with the gray card in frame so I could double check in post, and I even profiled the colors with the rite color checker passport.
As you can see the lights still look very yellow but the walls and everything else look fine. It did not look like this in person. The lights look white in person.
When I try to cool off the white balance in everything looks blue besides the lights. I ended up reducing the saturation for yellows but that effects some other things and it doesn't look quite right.
A while back I took almost the same photo but at night so you can see how it looks in person. Thats what the lights look like to my eyes.
View attachment 7ebd296a82a341889dcf7689b0cb12aa.jpg
So I can only assume the problem is the natural light coming in and raising the white balance of everything but the lights.
In this situation what am I supposed to do? Do I leave it like it is? Do I do a selective edit based on luminosity? What would people have done before photoshop to fix this if anything?
Thanks so much!
I took this photo yesterday for a client and I can't quite seem to get the white balance right hope you can help me figure out how I can fix this in the future.

You can see here the camera is facing away from a full glass exterior wall and there is a skylight up above. Most of the light is natural here. I set my white balance in camera using a gray card, I took a test shot with the gray card in frame so I could double check in post, and I even profiled the colors with the rite color checker passport.
As you can see the lights still look very yellow but the walls and everything else look fine. It did not look like this in person. The lights look white in person.
When I try to cool off the white balance in everything looks blue besides the lights. I ended up reducing the saturation for yellows but that effects some other things and it doesn't look quite right.
A while back I took almost the same photo but at night so you can see how it looks in person. Thats what the lights look like to my eyes.
View attachment 7ebd296a82a341889dcf7689b0cb12aa.jpg
So I can only assume the problem is the natural light coming in and raising the white balance of everything but the lights.
In this situation what am I supposed to do? Do I leave it like it is? Do I do a selective edit based on luminosity? What would people have done before photoshop to fix this if anything?
Thanks so much!
