Conditional Formatting on a Pivot Table - Formatting Options Icon not showing

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachements to open the upload window.

View Pic

I have in the attached used conditional formatting in a pivot table.

This one is better

I copied the formulas you used in the Conditional Formatting, but it's not expanding to new data when the Pivot Table expands. How can I fix this?

I even turned the Invoice Data range into a table then changed the Pivot table source to that table and it only partially works. The range for conditional formatting should change according to the table's change in size but it doesn't

I next expanded the range for the Conditional Formatting to exceed the data in the Pivot table (row 2000) and that works. So, make the range in Conditional Formatting something that will not likely be exceeded any time soon.

The repeating labels are created by right clicking in the Pivot table column that you want repeating labels in and then choose Field Settings. On the Layout and Print tab select Repeat item labels and click 0k.

There is formatting in the totals column that appears to interfere with the conditional formatting when the table is refreshed. I have tried several things to try and override this but have been unsuccessful.