Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keeping the fill color I've selected as the default
How do I keep the fill color from changing in Excel? When I change it to 25%
grey, save changes, close the application, then reopen, it's always changed back to yellow. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keeping the fill color I've selected as the default
Are you sure you do not have coonditional formatting turning it back to yellow?
-- Hth Kassie Kasselman "stevem" wrote: How do I keep the fill color from changing in Excel? When I change it to 25% grey, save changes, close the application, then reopen, it's always changed back to yellow. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keeping the fill color I've selected as the default
Excel has a finite set of colors as default. Open your project, got to
TOOLSOPTIONS and in the COLOR tab, change one of the unused colors to the color you want to retain and save your project. Before, when you closed then open your project it was reverting back to the default color, not the color you changed it to. Hope this helps you. -- Virg "stevem" wrote: How do I keep the fill color from changing in Excel? When I change it to 25% grey, save changes, close the application, then reopen, it's always changed back to yellow. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
keeping the fill color I've selected as the default
Assuming you are speaking of the default color in the color picker drop-down and
not in the cell, Excel likes yellow so the drop-down default is always yellow. Gord Dibben MS Excel MVP On Sat, 3 Feb 2007 09:08:00 -0800, stevem wrote: How do I keep the fill color from changing in Excel? When I change it to 25% grey, save changes, close the application, then reopen, it's always changed back to yellow. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Set default in auto fill options, I always want to copy cell, som. | Excel Discussion (Misc queries) | |||
How do I change fill color default in excel 2003? | Excel Discussion (Misc queries) | |||
Default fill color change | Excel Discussion (Misc queries) | |||
Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
help! dimension members how to not be selected by default | Excel Discussion (Misc queries) |