Conditional Formatting Issues

Hello,

Has anyone ever had an issue with Conditional Formatting where the text goes to the bottom left instead of middle centered like the cell indicates? Is there a way to adjust this from happening?

Yes here's my file, the conditional formatting is in Column E.

Originally Posted by TMS

Looks fine to me using Excel 2007. The text is centred vertically and horizontally as per the cell formatting and the colour is as per the CF conditions.

It starts out correct for me, but once I scroll down a page and then scroll page up it goes to the lower left. Does that have something to do with frozen panes?

I've attached a screenshot of what happens when I scroll down and then scroll back up.

Originally Posted by TMS

I can't reproduce that effect. Scroll down, Cursor down, Page down, whatever. No problem.

Hmm that's strange, wonder what it is.

Originally Posted by TMS

I have asked others for input: http://www.excelforum.com/the-water-...ml#post4355822

Thanks very much!

I just copied the tab into a new workbook and the issue went away, it must have something to do with that particular workbook.

I downloaded this workbook from a google doc file, could that have something to do with it? Maybe the conditional formatting is different?