colors
 

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

--
Message posted from http://www.ExcelForum.com

colors
 

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

--
Message posted from http://www.ExcelForum.com

colors
 

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

--

Vasant



"scottnshelly " wrote in
message ...
Is there an easy way to find out which background colors equal what
numbers?


---
Message posted from http://www.ExcelForum.com/