colors

S

scottnshelly

Is there an easy way to find out which background colors equal wha
numbers
 
S

scottnshelly

Nevermind,
I just saw the thread started by Hari that has four examples of what
wanted. i admit my mistake and my stupidity. For the records, i lik
the second example given the best. That was nice. i like how it lai
it out horizontally, and then put the number right in there. super
job
 
V

Vasant Nanavati

No, because in theory, every workbook has its own color palette which can be
modified by the user. So a ColorIndex of 3 may represent a different color
in different workbooks.

Having said that, most users don't modify the default palette. This macro
will help you to see what ColorIndex represents what color in your workbook:

Sub ShowColors()
Dim i As Integer
For i = 1 To 56
With Cells(i, 1)
.Value = i
.Interior.ColorIndex = i
End With
Next
End Sub
 
Top