Macro failing at conditional formatting font colour

Thanks for the quick reply! Unfortunately this gives me the same kind of error, Run-time '1004'/Application-defined or object-defined error, highlighting the row beginning '.colour' at this point:

Formula:

With .FormatConditions(1)

            With .Font

                .Color = 393372

                .TintAndShade = 0

            End With

I ran a repair install of Office 2007, just in case, but still no joy.