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"

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"

Create a Tartan Pattern in Excel

Suddenly, it's November, and it's time to plan what you'll wear on St. Andrew's Day (November 30th). He is the patron saint of Scotland (and other countries), so of course you'll need a kilt, made in your family tartan. Fortunately, you can create a tartan pattern in Excel, if your family doesn't have a tartan. Thanks to John Marshall for creating this handy tool.

Continue reading "Create a Tartan Pattern in Excel"

Excel Hyperlinks Run Command Files

You can use Excel hyperlinks to navigate through a workbook, go to web pages, open other Excel files, and even open PDF files. However, if you try to use an Excel hyperlink to run command files, you'll run into problems. Until now! Here's how J.Woolley uses hyperlinks, with a background macro,  to avoid those problems – and a other problems too. He also found a strange hyperlink bug.

Continue reading "Excel Hyperlinks Run Command Files"