Hey Guys,
I was wandering if there is a quick way to represent every zero in a summary table as blank/ " ". I would not like to add an if statement if that is possible, because the formula is pretty long. To be more clear, I do not want to have if(sumifs(bunch of stuff)>0,sumifs(bunch of stuff), ""). Thanks of the help
MacBook Pro, OS X Yosemite (10.10.1), and iMac
Hi Charles,
Conditional Highlighting: Equal to 0, Custom Style, White Text
Regards,
Ian.
Hi Charles,
Conditional Highlighting: Equal to 0, Custom Style, White Text
Regards,
Ian.
Thanks Ian,
I knew I was thinking to hard.
Or a custom format. Set up whatever format you want for the cells when they are not equal to zero then add the condition "if equal to zero" and clear all the formatting from that one. Hopefully it will be clear in the screenshot.
Badunit,
Thank you for the tip. Your example was clear and I have made a custom format for the table. I didn't know that you could add a rule in a custom format. That is good to know though.
Conditional Formatting?
