Cell Alignment Automatically Changing

[timgolden]

Hello,

I have a spreadsheet that is center aligned, however, every time I scroll over the cells it changes them to be right aligned. It does this for every other line so in other words it only changes every other row into the right alignment.

[/IMG]

 

[timgolden]

I realized that the conditional format I had set (mod(row(),2)=0) was throwing off the alignment. Once I removed the conditional format, everything seemed to align properly. I suppose my question is now, does anyone know what causes conditional format to do this and is there a workaround to use conditional format and have it centered properly?