I added a formula to highlight two cells if the condition is not met. When I refresh the pivot the second column is unhighlighting and when I check the ranges I see that it stops being absolute and duplicates and adds a new range. Basically when column C or D doesn't meet the condition then it should highlight the cell along with the cell in the same row under column A.
I added an example of how the range should look like vs how it looks after a refresh.
Screenshot 2024-03-20 163426.png
Screenshot 2024-03-20 163238.png
Bookmarks