highlight pivot table rows under condition

[Goodstart14]

Hi,
I want to highlight if text are ending "AB".
I have a pivot table and in the row column, I have column, "Items".
The pivot table looks like below;

Name | Task | Items | Total Hours
John K. QWE Q-AB 3.00
John K. Send P-AB 1.00
John K. Total Hours 4.00
Kate C. Fix Hole 2.00
Kate C. Tra City-AB 9.00
Kate C. Total Hours 11.00
Grand Total 15.00

I want to highlight Q-AB, P-AB, and City-AB in yellow.
I used conditional formatting, but when new data entered, the conditional formatting didn't work for new range.
I have to fix the range manually.
How can I do this with vba?

Thanks in advance.

[David A Coop]

Hi Goodstart,

I have tried a couple of possible answers.

Goodstart14 - CF Examples.xlsx

First of all, with the newer versions of Excel (2007+) you have Pivot Table Conditional Formatting, but it can only be applied to VALUE fields. Hence, in the first PT you see the hours column has been highlighted.

However, I got the impression that you wanted to have the TEXT highlighted, not the numbers.

In the second PT I have achieved this by nominating the whole of column H as the range the CF Applies To.

I hope this helps, please let me know!

Regards,

David

Please remember, your request is clearer if you attach a sample workbook.
- Click on Go Advanced and click on the Paper Clip.

If this has been of assistance, please advise.
- Please click on the *Add Reputation button at the bottom of helpful responses.

Please mark your thread as SOLVED:
- Click Thread Tools above your first post, select "Mark your thread as Solved".