Conditional Format Pivot Table

[brent_milne]

I have column 'F' that right now has the number 1 if an event has been cancelled during the month. I was hoping to find a way to use conditional formatting to change the number 1 to the word 'Yes' if it was cancelled. I was somewhat successful until I noticed that the monthly subtotal would have 'Yes' if there was only one cancellation. The only work around I could think of was to format the subtotal to display 1 if it had the word 'Yes' in the subtotal cell but I am not sure how to do this. Thanks for any help with this.