I have the attached spreadsheet however I cannot get the blank cells to be white (I.e. no conditional formatting applied to them when they are blank), I had added the conditional format too of be white should the cell be blank, however it does not seem to work.
you have it correct you just need to move the 'is blank' rule above the others and, optionally, tick 'stop processing' - excel treats a blank as 0 in this context so you are getting two conflicting formats
MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents.
Type out your initial …
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.