Conditional formatting formula not working in pivot table

  • Hi,


    I will appreciate if you could help me with the following:
    In Excel 2016 worksheet, I applied the following “Conditional Formatting” formula =AND(D$6>=$B7,D$6<=$C7) and it is working well. However, with this worksheet, I created a pivot table with the same “Conditional Formatting” and the same formula, but, the formula did not affect the pivot table data. Is there a way to apply this Conditional Formatting formula to the pivot table?


    Thanks.


    George.