Colors Keep Changing

[QuestionMan]

I'm hoping someone can help me. I have an Excel 2003 sheet with multiple tabs. I have some of the fields with a fill color of 25% gray to distinguish years. It seems that after a day or so, when I re-open the file, the fill color switches to Indigo. Can anyone help me figure out how to stop this from happening.

There is a simple macro that sorts by year and by price, but as far as I can tell it has nothing in the macro that should change the color.

Thank you in advance.

 

[Trevor G]

Do you have any conditional formatting applied?

 

[QuestionMan]

Trevor,

I do. Some that change the font, some that change the fill color if a certain number is exceeded.

 

[Trevor G]

Can you state what are your conditions you are using as this maybe the issue.

 

[QuestionMan]

I have one set of cells that if a value is not between -.05 and .05 it turns the font red.

On different cells I have two conditional formats:

If the cell is greater than 0 the fill format turns the background to red.
If the cell value is less than -.35, the font turns red.

 

[Trevor G]

I think I would need to see your workbook to see what is happening as the conditional formatting shouldn't change the colour to Indigo.

Do you have any styles within the workbook?

 

[QuestionMan]

No styles. It's a pretty generic sheet. Multiple tabs that use V-Look ups to bring some information from a separate tab. A simple macro sorts by value. Maybe I will try to get rid of the conditional format that changes the fill color and switch it to another color font instead.