I'm ready to replace all the florescent bulbs in the world! They cause me nothing but nightmares!
One of my more frequent indoor event venues is a combination of florescent, incandescent, and floor to ceiling windows along one side. No matter what camera WB setting/WB card/Color Checker I use, it is a complete waste of time! It all has to be corrected in post processing, in my opinion. Yes, using a flash to 'override' the florescents will solve the problem. But then you're dealing with overexposed faces and light dropoff issues inherent with flash.
When photographing people, trying to 'freeze action' on them using a shutter speed of 1/60th will result in a number of blurred faces/hands/etc. At that speed, my experience has been about half or more come out blurred. So, I try to shoot at 1/125th and faster to 'freeze' them. But at the higher speeds, the 60 cycles/second of the florescents causes colors to come out that have radically different color tints in every frame. Even taking shots as fast possible without moving the camera causes every frame to have different WB. Of course, as subjects move around and hence under different lighting combinations, the color shifts worsen further.
So, I fix the problem in Lightroom using the WB 'eyedropper' tool. I find anything that is fairly white and click on that. Shirts and shirt collars are my usual targets, but papers, even sheet music will do. Then I'll use the WB sliders to get things closer to what I want. Sometimes, it will also be necessary to use individual color adjustments (hue/saturation/luminence) to get what I want. Then start over again on the next photo. If there's several photos in a series, I'll go back and adjust some more to get them all to the same appearance, otherwise, the viewer would see minor color shifts from frame to frame.
Yes, I'm just a 'hacker'. Sometimes, after spending maybe 20 minutes trying to get the best WB across a small series of images, I'll end up just making them as best I can and be done with it. Then this year, at a school Christmas concert I've shot for several years, they put in new LED lighting across the front of the stage, and still had the old incandescents lighting the rear half of the stage. Without extensive work on each photo using Photoshop Elements to separate the images into layers and processing each individually, the only choice is to make the kids in the front or performing solos or in a skit WB colors accurate, and let the kids in the rear have a 'bluish-purple' caste to them.