Color Index

Posted by Robb on October 08, 2001 12:29 PM

Does anybody have a table, or is there a table, that shows what color matches what colorindex number.

Thanks.

Posted by dank on October 08, 2001 12:59 PM

There's a table in the Excel 2000 VBA help. Type ColorIndex into the index of the help and select ColorIndex Property.

regards,
Daniel.

Posted by Gianni Rivera on October 08, 2001 2:59 PM

Also, you can produce your own table with the following (from a MrExcel tip at http://www.mrexcel.com/qa.shtml) :-

Public Sub ColorTable()
Dim i As Integer
For i = 1 To 56
Range("A" & i).Interior.ColorIndex = i
Range("B" & i).Value = i
Next i
End Sub