Hello i have the following data :


    Year	Month	DAY	Value	Flag
    2016	Jan	01	10	Y            <=  Note same date, one entry with
    2016	Jan	01	15	N            <=  Y and the other with N
    2016	Feb	02	10	N
    2016	Jan	09	30	N
    2016	Mar	03	20	N
    2016	Apr	01	10	N            <=  Note same date, one entry with
    2016	Apr	01	10	Y            <=  Y and the other with N
    2016	May	06	20	N
    2016	Jun	01	40	N

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

            01	02	03	06	09      <== Days
    Jan	    25				30      <== Sum of the values from this day
    Feb		10			        <== Sum of the values from this day
    Mar			20		        <== Sum of the values from this day
    Apr	    20				        <== Sum of the values from this day
    May				20	        <== Sum of the values from this day
    Jun	    40                                  <== Sum of the values from this day
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 ?