Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I can't change colors in certain Excel cells
A colleague created an Excel worksheet. When entering info in certain cells
he has highklighted in yellow, I can't change the clor or if I do, when I save, the changed cell reverts back to its original yellow |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I can't change colors in certain Excel cells
On Wed, 12 Jul 2006 15:22:01 -0700, ArmyDad
wrote: A colleague created an Excel worksheet. When entering info in certain cells he has highklighted in yellow, I can't change the clor or if I do, when I save, the changed cell reverts back to its original yellow It sounds like the cells have a conditional formatting applied? If the condition is met it will over-ride the normal default setting. HTH __ Richard Buttrey Grappenhall, Cheshire, UK __________________________ |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
I can't change colors in certain Excel cells
Two things I can think of.
1. FormatConditional Formatting is producing the color. Select one of the cells and check to see if any CF applied. 2. Event code is changing the color. The event code could be in Thisworkbook module or in the sheet module. Right-click on the sheet tab and "View Code" to see if any code there. Right-click on the Excel Icon at top left of menu bar and "View Code" to check for code. Let us know what you find. Gord Dibben MS Excel MVP On Wed, 12 Jul 2006 15:22:01 -0700, ArmyDad wrote: A colleague created an Excel worksheet. When entering info in certain cells he has highklighted in yellow, I can't change the clor or if I do, when I save, the changed cell reverts back to its original yellow |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
How to change mixed case to upper case in Excel for all cells | Excel Discussion (Misc queries) | |||
How do I create custom fill colors (for cells) in Excel 2002? | Excel Discussion (Misc queries) | |||
Is it possible to change colors of cells based on value in cell (. | Excel Worksheet Functions | |||
How to get excel cells to change colors depending on value | Excel Worksheet Functions |