Ok so I am sure this simple, but it have me foxed. I have a pivot table, which looks like below:
[TABLE="width: 500"]
<tbody>[TR]
[TD]Hub[/TD]
[TD]Role[/TD]
[TD]B/F/A[/TD]
[TD]Sum of 23-2015[/TD]
[TD]Sum of 24-2015[/TD]
[TD]Sum of 25-2015[/TD]
[/TR]
[TR]
[TD]Longbridge[/TD]
[TD]Civils Site Supr[/TD]
[TD]Budget[/TD]
[TD]0.20[/TD]
[TD]0.25[/TD]
[TD]0.30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Forecast[/TD]
[TD]0.20[/TD]
[TD]0.25[/TD]
[TD]0.30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Actuals[/TD]
[TD]0.10[/TD]
[TD]0.25[/TD]
[TD]0.35[/TD]
[/TR]
</tbody>[/TABLE]
This is repeated for multiple roles and hubs. I want to apply conditional formatting to the pivot so that when the actuals figure is higher than the forecast figure the cell turns red, for example.
What I am trying to avoid is setting the conditional format for each cell indivdiually. It will obviously need to extend if addtional roles are included or additional weeks (sum of xx-2015)
Any help much appreciated.
[TABLE="width: 500"]
<tbody>[TR]
[TD]Hub[/TD]
[TD]Role[/TD]
[TD]B/F/A[/TD]
[TD]Sum of 23-2015[/TD]
[TD]Sum of 24-2015[/TD]
[TD]Sum of 25-2015[/TD]
[/TR]
[TR]
[TD]Longbridge[/TD]
[TD]Civils Site Supr[/TD]
[TD]Budget[/TD]
[TD]0.20[/TD]
[TD]0.25[/TD]
[TD]0.30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Forecast[/TD]
[TD]0.20[/TD]
[TD]0.25[/TD]
[TD]0.30[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Actuals[/TD]
[TD]0.10[/TD]
[TD]0.25[/TD]
[TD]0.35[/TD]
[/TR]
</tbody>[/TABLE]
This is repeated for multiple roles and hubs. I want to apply conditional formatting to the pivot so that when the actuals figure is higher than the forecast figure the cell turns red, for example.
What I am trying to avoid is setting the conditional format for each cell indivdiually. It will obviously need to extend if addtional roles are included or additional weeks (sum of xx-2015)
Any help much appreciated.