Conditional Formatting - not working
 

All:

I have a sheet with conditional formatting applied, the conditions work but
once I save and come back, when the specific conditional format is triggered,
it looks like nothing happened. When you scroll up/down or switch between
tabs and then come back, that's when the conditional formatting is visible.
Working in Excel 2007 and it's important for users to see the formatting
happening in view, and not having to scroll back and forth to see the
changes. Any thoughts why this is happening?

Thank you.