Setting a ColorIndex property to xlAutomatic causes Excel to use the current default fill colour.