Changing cell font colour with VBA....excel 2007 to 2010 compatability issue?

[qaliq]

I have some code where part of it formats all my cells in a table to be italic and grey.

 With Selection.Font
        .Name = "Calibri"
        .FontStyle = "Italic"
        .Size = 11
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ThemeColor = xlThemeColorDark1
        .TintAndShade = -0.349986266670736

I just made this by recording formatting one cell and then applying it to a range.

When I try and run this however, it formats the text as white! Does anyone know what i'm doing wrong!? I've tried with different colours but still everytime it formats all text white.

I've just switched from 2007 to 2010 but I wouldn't have thought this would have been an issue?

Thanks,

Alice

[nathansav]

ive heard they are reversed.

try changing it to colordark2 or use the .color or .colorindex

[JosephP]

it's a bug in 2010-TintAndShade doesn't work with cell fonts! it has been fixed in 2013 I think

if you can use an rgb color value instead that oughta work