This is kind of hard to explain, so I've attached the workbook.
IN the raw data I've created a column (Final Percent of Target) with values 1,2,3 (good, moderate, bad) based on whether or not the values are some percentage of their targets. When placed in a pivot table, I conditionally format this column and call it performance to green , yellow and red. All is well.
However to save space, I would like to color code the actual values the same as the
performance column, and then perhaps hide this column.
I could envision how to do this outside of a pivot table, but not within the pivot table.
Any work-arounds, solutions, help greatly appreciated.