Re: Excel 2003 ir Excel 2007 spalvu paletes (html) [Jornada Del Muerto @ 2010-11-24 11:45:28]

Tema: Re: Excel 2003 ir Excel 2007 spalvu paletes (html)
Autorius: Jornada Del Muerto
Data: 2010-11-24 11:45:28
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1257" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.6001.18975">
<STYLE></STYLE>
</HEAD>
<BODY>
<DIV><FONT size=2 face=Arial>&nbsp;&nbsp;&nbsp; Kiek pagooglines 
suzinojau:&nbsp;</FONT><A href="http://www.cpearson.com/excel/colors.aspx"><FONT 
size=2 face=Arial>http://www.cpearson.com/excel/colors.aspx</FONT></A><FONT 
size=2 face=Arial>&nbsp;</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=1 face=Arial>&nbsp;&nbsp;&nbsp; The Color palette</FONT></DIV>
<DIV><FONT size=1 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=1 face=Arial>&nbsp;&nbsp;&nbsp; Excel supports colors for fonts 
and background fills through what is called the Color palette. The palette is an 
array or series of 56 RGB colors. The value of each of those 56 colors may be 
any of the 16 million available colors, but the palette, and thus the number of 
distinct colors in a workbook, is limited to 56 colors. The RGB values in the 
palette are accessed by the ColorIndex property of a Font object (for the font 
color) or the Interior object (for the background color). The ColorIndex is an 
offset or index into the palette and thus has a value betweeen 1 and 56. In the 
default, unmodified palette, the 3rd element in the palette is the RGB value 255 
(&amp;HFF), which is red</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face=Arial>&nbsp;&nbsp;&nbsp; Zodziu kaip sakant excel naudoja 
indexed colors 56 spalvu RGB&nbsp;paletes,&nbsp;o palete galima paciam 
definint:</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=1 face=Arial>&nbsp;&nbsp;&nbsp; You change the values in the 
default palette by modifying the Colors array of the Workbook object. For 
example, to change the color referenced by ColorIndex value 3 to blue, use 
</FONT></DIV>
<DIV><FONT size=1 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT face=Arial><FONT size=2>&nbsp;<STRONG>&nbsp;&nbsp; 
Workbooks("SomeBook.xls").Colors(3) = RGB(0,0,255)</STRONG></FONT></FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face=Arial>&nbsp;&nbsp;&nbsp; Cia kiek suprantu color index 
spalvos nustatymas, jei skirtingose vietose skiriasi ir nori suvienodint tai 
gali vieno excelio palete tokiu pat budu paimti kaip ir priskiri ir 
inicializuoti ja kitam.</FONT></DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face=Arial>P.S. 1st answer on google, by search text: 
<STRONG>VBA rgb color</STRONG></FONT></DIV>
<DIV><FONT size=2 face=Arial>JDM </DIV>
<DIV><BR><BR></DIV></FONT>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face=Arial></FONT>&nbsp;</DIV>
<DIV><FONT size=2 face=Arial>"b2b" &lt;</FONT><A 
href="mailto:b2b@gmail.com"><FONT size=2 
face=Arial>b2b@gmail.com</FONT></A><FONT size=2 face=Arial>&gt; wrote in message 
</FONT><A href="news:icice6$47h$1@trimpas.omnitel.net"><FONT size=2 
face=Arial>news:icice6$47h$1@trimpas.omnitel.net</FONT></A><FONT size=2 
face=Arial>...</FONT></DIV><FONT size=2 face=Arial>&gt; Sveiki,<BR>&gt; <BR>&gt; 
exceliuos 2003 ir 2007 skiriasi spalvu paletes. Rasant macrosa 2007 excelyje 
<BR>&gt; nurodau iprastini spalvos indexa/koda (2, 3, 4 6 arba 47), o man 
nuspalvina <BR>&gt; arba kazkiek tamsiau arba sviesiau. Gal zinot kokie yra 
spalvu kodu <BR>&gt; atitikmenys 2007 excelyje ? <BR>&gt;</FONT></BODY></HTML>