Not Correct -Range("A1:A6").Interior.Color =RGB(85

[keeva]

I've used this in a Macro in order to create a custom background color on some cells. The article is here http://www.mrexcel.com/td0070.html

Range("A1:A6").Interior.Color = RGB(85,116,185)

The problem is Excel creates RGB(102,102,153) - which is a default Excel color - instead of the true RGB(85,116,185) color.

Anyone know how to create custom cell background colors? The above macro VBA doesn't seem to create a truely custom color.

thanks,

- Kevin

 

[Von Pookie]

I assume that's probably because you are (unfortunately) limited to the default colors available in the Excel color pallet.

The information here may help: http://www.cpearson.com/excel/colors.htm

 

[Tazguy37]

Re: Not Correct -Range("A1:A6").Interior.Color =RG

Which color from the fill dropdown do you get? I don't get any of them, and none of them look the same as RGB(85,116,185).

 

[halleyf]

Re: Not Correct -Range("A1:A6").Interior.Color =RG

in Tools >> Options >> Color.

Those are the colors you can use in the window. you can change these, by clicking the modify button after selecting a color to change. if you aren't plannning on having graphs, i recommend changing the two bottom rows of colors. you can also change the available colors from VB. record a macro of the above process to see how.

 

[keeva]

Re: Not Correct -Range("A1:A6").Interior.Color =RG

Thank you halleyf!!

You had the very easy solution : )

- Kevin