I have a pivot table with 2 columns. I would like the cell color for the TOTAL cell to be a certain color based on the value in the cell. I have tried using conditional formatting on the total cell but when I select the 2nd cell, both totals have the same formula. I also tried removing the absolute value indicator from the formula so it would adjust but that didn't work. Following is the color key I am trying to accomplish. A sample file is attached.
Sum of 31 - 60 Days
<5,000 = Green
5,000-15,000 = Purple
Over 15,000 = Red
Sum of 61-90 Days
<10,000 = Green
10,000 - 50,000 = Purple
Over 50,000 = Red
Bookmarks