In Excel 2007, if I do:

Selection.Interior.ThemeColor = xlThemeColorLight1
Selection.Font.ThemeColor = xlThemeColorDark1

then I'd expect to see dark (black) text on a light (white) background, but
I'm actually getting the opposite - light text on a dark background. It's
also wrong if I try it the other way around and xlThemeColorDark2 and
xlThemeColorLight2 seem to be reversed in the same way, too. (And, no, I
haven't changed the theme colours from default).

Am I missing something completely obvious? I can't work out how this can be
expected behaviour. I'd be grateful if anyone could enlighten me.

Thanks
Chris