Hi,
Can somebody show me the code for a UDF that shows the color index number of a cell value in excel?
Thanks
Function ColorIndex(rCell As Range,Optional FontOrInterior As Integer = 0) As Integer
If FontOrInterior Then
ColorIndex = rCell.Interior.ColorIndex
Else
ColorIndex = rCell.Font.ColorIndex
End If
End Function