Excel Conditional Formatting Colour Macro Problems

If you need to know what color is in a worksheet cell, or a shape, you can check it manually, or use VBA code to find the color number. There are conditional formatting color macros too, but they’re a bigger challenge, and didn’t work for a project that I built recently. Here’s what I was working on, and some of the Excel color resources that I used along the way. There are links to download my sample file, and one from Visio MVP, John Marshall. Continue reading “Excel Conditional Formatting Colour Macro Problems”

Hockey Player Data Analysis in Excel

Congratulations to the USA Women’s Hockey team, who won the Olympic gold medal. They beat our Canadian team, in a hard-fought game that went into overtime, and ended with a shootout. The team rosters were available online, so I used those for a hockey player data analysis, in Excel pivot tables. Is there anything in the player data that shows why the USA team won?

Continue reading “Hockey Player Data Analysis in Excel”

Excel Budget Report with Value Selector

Instead of showing a budget’s forecast, actual and variance data all at once, click a button to view the values one at a time. That makes the report easier to read, and takes less space on the worksheet. See how this technique works in my Budget Reporter with value selector workbook.

Continue reading “Excel Budget Report with Value Selector”

Show Warning in Excel Drop Down

With Excel’s data validation, you can show a drop down list of items in a cell. You can even create “dependent” drop downs. For example, select a region, and see only the customers in that region. See how to show a warning in Excel drop down list, if the source data is not set up correctly.

Continue reading “Show Warning in Excel Drop Down”

Create and Copy AutoCorrect List Items

To save time, create AutoCorrect entries for words, phrases, and even symbols that you type frequently. Then, type a short code, and Excel automatically changes it to the full text. See how to create an entry, then print a list of all your entries, and copy them to a different computer, using the AutoCorrect macros below.

Continue reading “Create and Copy AutoCorrect List Items”