Hello i have the following data :


Please Login or Register  to view this content.

Based on this table that has hundreds of lines, i built this pivot table :

Please Login or Register  to view this content.
My question is, based on the FLAG=Y how can i change the background for the cell to red on the pivot table ?
I canīt use conditional format based on the sum of the value, because it varies a lot.
The day should be painted as red, based on the FLAG = Y.
As per example above the Jan/01 & Apr/01 should be red on pivot table

Any suggestions ?