View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default Custom Color/Color Index

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)



"FARAZ QURESHI" wrote in message
...
Hey Bob!

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

Thanx Again
--
Best Regards,

FARAZ A. QURESHI


"Bob Phillips" wrote:


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" wrote in message
...
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!