Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shading cells - how to pick a slight/different shade of a color
I am using the grey shade on cells. However, in some instances the dark grey
is ok, in other instances I would like to use a lighter grey. I do not see where you can go to advance options to either use RGB coding or modify the colors in the palette. Thanks, -- Mark |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shading cells - how to pick a slight/different shade of a color
You can change the indexed colors by clicking on Tools/Options on Excel's
menu bar, selecting the Color tab, clicking a color you want to change in the grid of colors, then clicking the Modify button, then pick either an existing "Standard" color or a "Custom" color via the tabs at the top of the dialog box. -- Rick (MVP - Excel) "Mark" wrote in message ... I am using the grey shade on cells. However, in some instances the dark grey is ok, in other instances I would like to use a lighter grey. I do not see where you can go to advance options to either use RGB coding or modify the colors in the palette. Thanks, -- Mark |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shading cells - follow up
First, thanks for the quick response.
I followed your instructions. What happened was that the new shade I selected actually replaced the one being edited. It automatically changed the shading in my excel sheet. Is there a way to modify an existing shade, but add the new shade as being a new color to choose? Thanks, -- Mark "Rick Rothstein" wrote: You can change the indexed colors by clicking on Tools/Options on Excel's menu bar, selecting the Color tab, clicking a color you want to change in the grid of colors, then clicking the Modify button, then pick either an existing "Standard" color or a "Custom" color via the tabs at the top of the dialog box. -- Rick (MVP - Excel) "Mark" wrote in message ... I am using the grey shade on cells. However, in some instances the dark grey is ok, in other instances I would like to use a lighter grey. I do not see where you can go to advance options to either use RGB coding or modify the colors in the palette. Thanks, -- Mark |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shading cells - follow up
You must be using a version of Excel prior to Excel 2007...
You can have only a set number of colors. If you want a new color it must replace one of the current colors. The best way to do this is to replace one of the colors that you will/would never use. -- Biff Microsoft Excel MVP "Mark" wrote in message ... First, thanks for the quick response. I followed your instructions. What happened was that the new shade I selected actually replaced the one being edited. It automatically changed the shading in my excel sheet. Is there a way to modify an existing shade, but add the new shade as being a new color to choose? Thanks, -- Mark "Rick Rothstein" wrote: You can change the indexed colors by clicking on Tools/Options on Excel's menu bar, selecting the Color tab, clicking a color you want to change in the grid of colors, then clicking the Modify button, then pick either an existing "Standard" color or a "Custom" color via the tabs at the top of the dialog box. -- Rick (MVP - Excel) "Mark" wrote in message ... I am using the grey shade on cells. However, in some instances the dark grey is ok, in other instances I would like to use a lighter grey. I do not see where you can go to advance options to either use RGB coding or modify the colors in the palette. Thanks, -- Mark |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Shading cells - follow up
Excel is limited to 56 colors.
If you modify one then the original is gone. Only way to apply an additional color to a cell would be through VBA using RGB numbers. Or pick some color that you would never use and modify it. Lavender or Rose come to mind as colors I would never employ. Make one of those your new gray color. Gord Dibben MS Excel MVP On Thu, 1 Jan 2009 12:35:01 -0800, Mark wrote: First, thanks for the quick response. I followed your instructions. What happened was that the new shade I selected actually replaced the one being edited. It automatically changed the shading in my excel sheet. Is there a way to modify an existing shade, but add the new shade as being a new color to choose? Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Color shading on cells posted 11/5/2008 ans. by Mr. Johnc | New Users to Excel | |||
Color shading on cells with same numeric content on three digit ce | New Users to Excel | |||
How can I count the number of cells with a particular color/shade | Excel Worksheet Functions | |||
how to set shading color of selection when i am selecting cells? | Setting up and Configuration of Excel | |||
Count IF function for color/shading of cells | Excel Discussion (Misc queries) |