Excel Cells Changing Background Colors

[Robert Mitchell]

I am using Excel 2003.

The problem I am having involves an excel file that has eight worksheets.
The eighth worksheet is linked to the other seven worksheets. Once I close
the workbook and do other work and open the same file again later the
background color has changed for certain cells.

I have tried to close the file and open it again, but it is still there. I
then reset the background color (white). What makes it weird is the
background color it changes to is not one of the colors used in the
worksheet. When I get finished fixing the workbook and I close the file it
comes back again when I open the file. It is not always the same color that
is in the cell.

Would appreciate any suggestions how to fix this.

Bobby Mitchell

 

[CLR]

Hi Robert...........

No telling what is causing that weirdness............assuming the file works
the same way on other computers, which would indicate the trouble is indeed
inside the Excel file.......I think I would start looking at conditional
formatting, and/or macros.

hth
Vaya con Dios,
Chuck, CABGx3

 

[David McRitchie]

The toolbar color buttons do not show all 56 palette colors. To see
the full 56 color palette try
tools, options, colors

Select a cell where the color appears, format, conditional formatting
Do you see any conditions listed indicating Conditional Formatting.

Check Format, Style, is it other than normal.

Right click on the sheet tab, do you see code there especially code
that involves color.

If you select multiple cells in Excel 2000 and up the selection has
a unique color kind of a steel gray blue color. Can you select
cells or are you prevented from selecting. Do you see EXT
or ADD on the status bar at the bottom of the sheet, if you do
hit F8 once or twice until they disappear.