| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Custom Color/Color Index
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Color/Color Index
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Color/Color Index
Sure was a Great 1
Thanx!!! -- 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Custom Color/Color Index
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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Powerpoint / Excel: custom pp RGB color doesn't match identical Excelcustom RGB color | Charts and Charting in Excel | |||
| nested color index within sumproduct | Excel Worksheet Functions | |||
| Chart axes color index vs font color index | Charts and Charting in Excel | |||
| Public Function - Color Index | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
