Pivot Tables + Color + Dynamic Content generation and display

[Pik]

I have a dynamically generated pivot table (generated from actions in
another spreadsheet - number of rows and location keeps changing -
cant use conditional formatting).

The data I currently have displayed on the pivot table is:
Resource Project Allocation Jan Allocation Feb
-------- ------- -------------- --------------
Resource1 Project1 0.5 0.5
Resource1 Project1 0.25 0.5
Resource1 Total 0.75 1.0
Resource2 Project1...
..

I need to
(1) Highlight, in red, items where Resource totals are less than 1.00.
e.g. Resource 1 Total. Just highlighting the 0.75 item is sufficient.
(2) Dynamically modify the pivot table contents to display only
resources where totals are less than 1.00 for the "current" month.

How do I do this?

 

[Microsoft]

In pivot table wizard layout, select the current month and look at advanced,
select to show only data < 1.

 

[Pik]

What exactly do you mean? Can you provide me with detailed steps/menu
options to use?
Basicically, can I filter subtotals to show only when allocation is <
1?