MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Color Index for Excel VB

Posted by Paul Magruder on May 02, 2001 7:51 AM

Does anyone know where I can find the color index excel uses for cell interior?
Red = 1?
blue = 2?

Thanks in advance

Posted by lenze on May 02, 2001 9:28 AM

Open the Visual Basic Editor and choose help. Type in Color Index<Search and you can view a color chart

Posted by Bj on May 02, 2001 11:36 AM

Try this to...

Sub Color()
For x = 1 To 56
Cells(x, 1).Select
Cells(x, 2).Value = x
With Selection.Interior
.ColorIndex = x
End With
Next x
End Sub