 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2008Cell colors
Excel 2003, sp2 Hi, I want to use a very light grey color in some of the cells in a worksheet. RGB(234, 234, 234) should produce the color I want, but: Activecell.Interior.Color = RGB(234, 234, 234) results in a white color (Colorindex = 2). Can Excel only handle the 56 predefined colors returned by the ColorIndex function? Regards Pete Yep. But you could replace one of those 56 colors with the shade you want. Tools|options|color tab|modify This color scheme will travel with the workbook--it's not an application setting. If you have multiple workbooks that need this, you'll have to do it for each workbook. David McRitchie has lots more info here: http://mvps.org/dmcritchie/excel/colors.htm > Excel 2003, sp2 > [quoted text clipped - 11 lines] > Regards > Pete  SignatureDave Peterson |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.