Hi Viesta,

I'm afraid you are starting to confuse me.
I think your problem is that you are trying to reformat the cells
after you have entered your formulas. In this instance I think
you should be formatting all your cells before you do anything.
If this is not the case please explain your problem in more detail.

HTH
Martin