color codes

[Wazooli]

After seeing many posts regarding extracting the color value of a cell, I am
wondering where one can get a listing of default colors with their respective
codes.

 

[Ron de Bruin]

Hi Wazooli

Run this macro on a empty sheet


Sub ListColors()
Dim a As Long
For a = 1 To 56
Cells(a, 1).Interior.ColorIndex = a
Cells(a, 2).Value = a
Next a
End Sub


More info you can find here
http://www.mvps.org/dmcritchie/excel/colors.htm

 

[Wazooli]

Well, i did it by brute force, which works suprisingly well, just
inefficiently so. Anyway, after following another thread about extracting
cell color using a function getcolor(), I was wondering if there was a way to
assign cell color with a function. please be gentle - I have absolutely no
VBA skills.

 

[Ron de Bruin]

Hi Wazooli

No, not with a function ( only with code )
Or you can use CF, see Debra's site for examples
http://www.contextures.com/xlCondFormat01.html

 

[David McRitchie]

Hi Wazooli,
Chip Pearson has several functions for dealing with Colors
obtaining the value i.e. CellColorIndex
http://www.cpearson.com/excel/colors.htm

To change the color you have to use a SUB (subroutine).
http://www.mvps.org/dmcritchie/excel/colors.htm

But I think you have been working with code from your question
and interaction, so you really should have started in the programming
newsgroup instead of worksheet.functions, but same people
there as here so stick with this group until you get your answers
if not already solved.

The color index colors are listed on my page above (2nd reference),
but if the web is not handy for you some other time you will find
a list of colorindex values in the VBE help (not the Excel help).
I like my page better and it is easier for me to refer to.