Conditional format pivot table cells based on text

[JSAUS]

Hello

I'm trying to format the cells in two columns in my pivot table ("HourSummary") based on the text in said cell, but when I use the normal conditional formatting and then refresh it it disappears.
I want all "Yes" cells to be Green Fill with Dark Green Text. And all "No" cells to be Light Red Fill with Dark Red Text. Needs to refresh each time I refresh the table.
Happy to use VBA to achieve this.
Thanks

 

[JSAUS]

Solved by going through Conditional Formatting Manager (slowly!).