Show Your Own Excel Error Values

In a perfect world, nobody would ever make a mistake in Excel. Every formula would be flawless, and every bit of data would be valid. Unfortunately, that's not the case. When mistakes happen, there are built-in errors, like #N/A, but why not create your own Excel formula error values, and show those too?

Continue reading "Show Your Own Excel Error Values"

Highlight Top or Bottom Values in Excel List

With Excel's conditional formatting options, you can highlight cells based on their values, or add colour scales, icons and data bars to the cells. There are built-in rules to highlight top or bottom values, and you can also create your own rules, as shown below.

Continue reading "Highlight Top or Bottom Values in Excel List"

Excel Advent Calendar No Macros

December is only 2 days away, so it's time for an Excel Advent Calendar! I've made two new versions this year, and they don't use macros, just basic Excel features. Even if you don't need an Advent calendar, take a look to see how they're set up . You might find a use for these techniques in other projects.

Continue reading "Excel Advent Calendar No Macros"

Excel Mileage Lookup With Total Distance

If you're planning a vacation trip, Excel can help. It's a great place to keep your packing lists, and you can track your vacation spending too (if you really want to know the total!). I've just uploaded a new sample file that will show how far you'll travel. Select cities, and formulas do a mileage lookup, with total distance from start to end.

Continue reading "Excel Mileage Lookup With Total Distance"