In Excel 2007 I have several conditional formatting rules to change cell shading when the value in another cell meets criteria. All the rules work, but the cell shading does not immediately update; I have to refresh or "redraw" the screen by scrolling down, then scrolling back up.
I'm not experiencing this problem on Excel for Mac 2008 or with Excel 2003. Any thoughts on how to fix this refresh problem would be helpful. Or maybe it is a known bug.
Many thanks.
Bookmarks