Hi.
I am extracting data from Access using MicroSoft Query. Due to volume of data, I am taking into a Pivot Table. The table contains a "Targets" field in Row, "Month" field in Column, and has a calculated item in Data.
I need to change the colour & Bold of the values in Data based on whether it is <= 59% of Targets, Between 60% and 79% of Target, Between 80% and 100% of Target.
On top of this, I need to formatting to be applied irrespective of where the Targets fied is in the Pivot, and it has to be applied everytime the pivot is updated.
Att the moment I have it working using conditional formatting, but the moment my "Targets" is moved my formatting disappear.
The pivot is built in Excel 2003.
Thx
Leon
Bookmarks