Hi all,

Is there a table render the colorindex and color?

Clara
--
thank you so much for your help

http://www.mvps.org/dmcritchie/excel/colors.htm

Hth,
Merjet

clara

See David McRitchie's site for the color palette.

http://www.mvps.org/dmcritchie/excel/colors.htm

Or just run this macro from John Walkenbach

Sub ListColorIndexes()
Dim Ndx As Long
Sheets.Add
For Ndx = 1 To 56
Cells(Ndx, 1).Interior.ColorIndex = Ndx
Cells(Ndx, 2).Value = Hex(ThisWorkbook.Colors(Ndx))
Cells(Ndx, 3).Value = Ndx
Next Ndx
End Sub


Gord Dibben MS Excel MVP

On Tue, 1 May 2007 13:01:02 -0700, clara
wrote:

Hi all,

Is there a table render the colorindex and color?

Clara

There is also a color palette displayed in VBA help under "PatternColorIndex
Property".

"clara" wrote:

Hi all,

Is there a table render the colorindex and color?

Clara
--
thank you so much for your help

Good find Whiz

Surprising what a little digging through help can dredge up.


Gord

On Tue, 1 May 2007 14:13:00 -0700, JLGWhiz
wrote:

There is also a color palette displayed in VBA help under "PatternColorIndex
Property".

"clara" wrote:

Hi all,

Is there a table render the colorindex and color?

Clara
--
thank you so much for your help