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.