View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richard Buttrey Richard Buttrey is offline
external usenet poster
 
Posts: 296
Default 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
__________________________