PDA

View Full Version : Help: HOw many color is there in Excel



yurble_vn
09-08-2007, 11:57 AM
I read some where that excel have 56 color index.

But when count in color palette, I just see 5*8=40 color. SO, where is the rest?

mdmackillop
09-08-2007, 12:48 PM
Sub ShowColours()
Dim i As Long
For i = 1 To 56
Cells(i, 1).Interior.ColorIndex = i
Next
End Sub

yurble_vn
09-08-2007, 07:01 PM
Thanks Mackillop,

Just run it

BTW, What is the rule to index color in Color Palette ? I cant find out the rule

enfantter
09-09-2007, 05:50 AM
i also have less colors for the palette in vba, when fx i wanna do userform
or if i just wanna do a button

Bob Phillips
09-10-2007, 01:01 AM
Many of them are repeated, but you can override those repetitrions with custom colours.

rory
09-10-2007, 02:26 AM
You can see them all under Tools-Options-Color.