I have an Excel spreadsheet that I use to keep track of all my business expenses. In order to make it less cluttered, and easier on the eye, I wanted to get rid of all the repeated, irrelevant values in the columns that may not have an entry for each day. Here I am using a subset of the data, but it illustrates what I am trying to achieve:

Hiding zero values in a range or even a whole worksheet is easy. However, I wanted to hide the value of a cell if its' neighbouring cell was zero or blank. Here’s how I did it:

• Select the values in the column you wish values to be hidden (“Cumulative” in this case).

• On the Home toolbar click the “Conditional Formatting” button, select “Highlight Cells Rules” then “More Rules…”

• Ensure the Style is “Classic” and then select “Use a formula to determine which cells to format” in the drop-down. Enter “=$b2=0” in the text box. Obviously, my data is in Column B and starts in Row 2, so you will need to to adjust this as necessary.

• In the “Format with” drop-down select “Customised Format…”

• Select “Custom” under “Category” and then select (or enter) “;;;” for the “Type”

• Select “OK” twice

The “Cumulative” column now only shows data where there is an entry for that row in the “Miles” column: