Custom Color/Color Index

[FARAZ QURESHI]

Can you apply a self-defined custom color (an RGB Combination) 2 cell(s) via
a macro? If yes, kindly provide a sample.

How can I get a list of color index of pre-defined colors for their
application on cell(s)?

Thanx!

 

[Bob Phillips]

ActiveWorkbook.Colors(15) = RGB(211, 211, 211)
Activecell.interior.colorindex = 15

For i = 1 To 56

Cells(i, "A").Interior.Colorindex = i
Cells(i, "B").Value = i
Next i


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[FARAZ QURESHI]

Sure was a Great 1

Thanx!!!

 

[FARAZ QURESHI]

Hey Bob!

Does that mean that I can define only upto a maximum number of 56 colors?

Thanx Again

 

[Bob Phillips]

Yes, it means exactly that in pre-XL2007.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)