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 <(E-Mail Removed)>
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 <(E-Mail Removed)>
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