Hi,
Thanks for the replies - I was hoping I was just doing it wrong. Interestingly, If I load an Excel 2010 spreadsheet which ended up with the wrong colours into Excel 2007 then the colours are still wrong. If I load up the Excel 2007 spreadsheet into Excel 2010 then the colours are right, so Excel seems to know what it's doing, but driving Excel via VB.NET or VBA gets more complicated. I can't complain too much about these little features as it things like this that make my job more colourful!

Kristian