Colour in workbooks keeps randomly changing

**ryanch69** · 05-09-2013, 07:13 AM

I have had this issue for some time now and am struggling to find a fix which is affecting several of my colleagues

.

So, We are using Excel 2002 & Excel 2007 and for some reason all of the workbooks that we have open decide to randomly change the fill colours of nearly all the cells. The only reason this is an issue is that a lot of my work envolves me sending reports to clients and from a business perspective this does not look professional at all.

Does anyone know why this is happening or know how to resolve this issue?

To add to this, once the cells have changed colour, the original colour is no longer available to select.

Your help is much appreciated!

**AndyLitch** · 05-09-2013, 07:30 AM

I'm guessing here but try

1. Checking and deleting all conditional formatting
2. Checking for all event driven code and search for (CTRL-F) "Interior.Color" or even "Color"... Rem out lines that have this

**ryanch69** · 05-09-2013, 07:35 AM

Thanks for the suggestion AndyLitch,

Tried this and there was no conditional formatting on the sheet (deleted all anyways) and nothing that i could find using the (CTRL-F) function