Conditional Format not Updating
I have a conditional format in xl2007 that works (fill 9 adjacent cells), but
only if I leave the page and return. This CF is dependent on the value in
another cell, which can change from values 1-4 based on a groupbox radio
button choice. The target cell is formatted as a "number".
There are other CF's in the worksheet that change a cell fill color based on
that cell value, and they respond without leaving the page. I updated the
graphics card driver without any luck.
What do I need to get the CF cells to refresh automatically?
|