Hallo Mr. K.
Function Farbnamen(Zelle As Range) As String
FarbIndex = Array("Schwarz", "Weiß", "Rot", "Hellgrün", "Blau", "Gelb", "Rosa", "Türkis", "Dunkelrot", "Grün", _
"Dunkelblau", "Dunkelgelb", "Violett", "Seegrün", "Grau", "Grau", "Immergrün", "Pflaume", "Elfenbein", "helles Türkis", _
"Dunkelpurpur", "Koralle", "Meeresblau", "Eisblau", "Dunkelblau", "Rosa", "Gelb", "Türkis", "Violett", "Dunkelrot", _
"Seegrün", "Blau", "Himmelblau", "helles Türkis", "Pastellgrün", "Hellgelb", "Blaßblau", "Hellrosa", "Lavendel", _
"Gelbbraun", "Hellblau", "Aquablau", "Gelbgrün", "Gold", "helles Orange", "Orange", "Blaugrau", "Grau 40", "Grünblau", _
"Meeresgrün", "Dunkelgrün", "Olivgrün", "Braun", "Pflaume", "Indigoblau", "Grau 80")
If Zelle.Interior.ColorIndex > -1 Then
Farbnamen = FarbIndex(Zelle.Interior.ColorIndex - 1)
Else
Farbnamen = ""
End If
End Function