Not sure if it can be done but I need to know if there is a way to somehow show a value has changed in a pivot table after I refresh it. I have two total columns in my pivot table and as the totals change (increase) I need to know which ones they are. The values are conditionally formatted to reflect the values in a policy to show which level of corrective actions must be taken when reaching a certain number. With a large volume of people, I would like to easily see when which values.
Appreciate the help,
Bookmarks