I have the following code in my Dart Score Sheet and would like to be able to use the 56 colour ColorIndex instead of the 6 ColorAccent - can this code be modified to do this.
With .Range(Address(Team)(5)).Interior
            .Pattern = xlSolid
            .PatternColorIndex = xlAutomatic
            .ThemeColor = xlThemeColorAccent1
            .TintAndShade = 0.9
            .PatternTintAndShade = 0
        End With