I painted a whole cafe wall in what I thought was a calm sage green, but under the store lights it looked like baby puke | Color Theory in Practice - The Design Community Hub
Lighting can't fix a truly bad paint choice though. If it looks that off under store lights, it'll probably just look like a different shade of wrong in daylight. You're stuck with the actual color on the walls, not the lighting.