Well its not *that* weird... ;-)
If you look at [1.3.3] (then compare with [1.1.1] at the top:
Chances are your nice yellow paint reflects a range of frequencies centred about the yellow portion of the spectrum. With natural daylight (i.e. when the paint is reflecting light from a full spectrum source) it looks ok. With CFL illumination the paint will still reflect the same range of colours, however most of the ones that add up to give the characteristic you see in daylight, are now missing from the source. So you will instead see just the few spikes in output that the bulb can produce at frequencies not absorbed by the paint. This loses the subtlety of the colour.
Look at: