Any one had this problem before and knows how to update the conditional formatting?
For example, it can be challenging to set up conditional formatting rules like "highlight the top 20% of this range." When doing research, the team found that there were a set of very common things that users wanted to do with conditional formatting, many of which required writing formulas, although not all were obvious.
For example, when i change the cell contents triggering the rule true/false it does not refresh the relevant cells' formatting.
the only way i can get it to refresh is by scrolling away from the affected cell/cells and back again (so forcing the screen to refresh).
It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Summary: The conditional formatting user interface (UI) in Excel 2007 now makes it easier than ever to create rules that increase the impact of your data.