In Rainbows, as a title, implies a sense of comfort and delightfulness. There's a slight, if expected, twist at play. On a couple levels, then, In Rainbows is not any less fitting as a Radiohead album title than "Myxomatosis" as a Radiohead song title.
eBay