Hi All,
I have applied conditional formatting to a range of cells(For example from A1 to A10). If sum of this range is not equal to 100, then the specified range should be displayed in red color, otherwise in blue color. But when I change any of the cells from this range (which results the sum > 100), then that particular cell alone is getting changed to red color. If I scroll down or scroll right then remaining cells from that range is changed to red.
Please let me know why the worksheet is not getting refreshed properly?
Bookmarks