If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Conditional Format Pivot Table

Thread starter brent_milne
Start date Jun 13, 2019
Tags

cancelled conditional format subtotal word

brent_milne

New Member

Jun 13, 2019

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.