Conditional formatting corrupted (excel 2007)

Question

Hi,

I tried to make a conditional formatting which adjusts the number of decimals in a number in a cell, based on the contents of other cells, using a formula. It didn't work properly, it seemed that under some circumstances it would not apply the formatting, even though the formula returned TRUE. Then if one did some random operation in the sheet, e.g. moved a formula from one cell to another, it would suddenly apply the formatting, even though nothing that could impact the formatting rule was changed.

Now something even more strange happened. I cleared all conditional formatting rules from that cell to start over - but after that, the conditional formatting suddenly worked as intended!  Now I have conditional formatting in a cell which has no visible rules listed under the 'Conditional formatting rules manager'. The formatting varies the number of shown decimals depending on the value of some other cells, something that no build-in formatting would be able do.  Sadly, my excel file must be corrupted in some way, and clearly there must be a bug somewhere in the program since this could happen. Any comments, is there a bugfix to this?

Answer 1

The above explaination with sample data would help finding the ghost :)

BLACK BARRON

---

P.S : Please post back with the status of the issue. If this post was helpful to you, please vote for my post If this post has helped you resolve your issue, please mark my post as answered.

Answer 2

I am not copy/pasting anything. The conditional formatting was made 'from the ground' by creating a formula in the 'conditional rules formatting manager'. And now the formula for the cell in question is gone, but the conditional formatting is still there, working even better than before. There must a 'ghost' somewhere...

Answer 3

Are you trying to paste the data manually or from other source?

While pasting it, it might paste the format as well. Check with an sample file !