So I was able to get it to work, and I’m not sure why it works, but…
Adding a black solid into the spectrum comp and setting that layer to SCREEN causes the colouring effect to work.
I discovered this when I added another layer for an additional effect, but that layer was scaled so it only covered part of the spectrum.

You can see the white section at the top of the spectrum.
Like I said I don’t understand this behaviour, but I’m happy to have stumbled upon it, and to share in case someone else can use the info. ^___^