Formatting Bug in 2010??

**JimmyA** · 12-14-2010, 07:17 AM

Hello All

I have attached a spreadsheet to this post to hopefully show the issue I am having. If I change the value in Cell D3, Excel seems to format other cells in the sheet by filling them black.

I have never had conditional formatting set on this workbook so I am at a loss to figure out why this keeps happening. Even more strangely if I scroll down the sheet (so the table is not visible) and then back up to the top, the formatting seems to go and everything looks normal again.

I have sent this to 2 people in my office, 1 with 2010 and 1 with 2007 and the problem seems to be there for both.

Does this happen for other people and would this be viewed as a bug? I have searched for the problem on Google but have found nothing.

I have removed confidential data from this workbook.

Any comments or suggestions would be great.

Thanks in advance

Jim

**davesexcel** · 12-14-2010, 07:51 AM

Does it still do it?
I believe I right clicked on one of the cells, selected format cells, fill,no color.
When I noticed that cell did not change, I used the format painter for the rest of the cells.

**JimmyA** · 12-14-2010, 08:05 AM

Hi davesexcel

Thanks very much for your reply. This seems to have fixed it.

I did try this myslef but while selecting "no color" I also selected the pattern style to be blank. It seems doing both at the same time still causes the problem to happen. I have just opened your example and changed the pattern style and it seems to be fine now.

Would you say this was a bug or should I just put it down as "one of the those things"?

Thanks again

Jim