Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Custom shading colors
Excel only displays 56 colors on a cell background. As you said, there are
tied to the colorindex. If the user redefines the RGB value of the color index, then that will change the color displayed. The palette is retained with the workbook. All this pretty much echos what you have observed - just confirming it. You really have not control over this other than running a macro that sets the palette back to what you want it to be. You can get code for doing this by turning on the macro recorder while you modify the palette manually. http://www.mvps.org/dmcritchie/excel/colors.htm David McRitchie's Page on Color and Excel http://www.cpearson.com/excel/colors.htm Chip Pearson's Functions for Cell Colors Page -- Regards, Tom Ogilvy "pk" wrote in message ... I hope someone can help me out on this one please! I mixed a few new colors using RGB that I want applied to certain cells on a spreadsheet that will be shared among many users. The problem is, I noticed that setting RGB only changes the color pallette and if the user resets or changes their color pallette, then MY colors are all reset on the spreadsheet (and they look bad!) to THEIR settings. Apparently its all linked by the color index? i.e. If the user changes their color index, that change updates the spreadsheet color. Is there is foolproof (or at least better) way of applying custom shading to certain cells in a spreadsheet that will be more stable (i.e. less changeable)??? Your example code would be most helpful. Thanks in advance to all who respond... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom colors for cell shading in Excel | Excel Discussion (Misc queries) | |||
Alternate shading colors | Excel Discussion (Misc queries) | |||
Display shading and font colors in edit mode | Excel Discussion (Misc queries) | |||
Why do the colors or shading only show up in print preview in Exce | New Users to Excel | |||
How to add fill colors (cell shading) in EXCEL? | Excel Discussion (Misc queries) |