Hello @francisbarton,
I created an easier and more straightforward post here: Applying custom formatting to pivot table
Essentially, it is just getting the right cells to grey out if the condition was at least met for one of the observations within that cell.