Hello, Excellers. Today's blog post in the #formulafriday continuing series is a little bit different. Usually, we discuss formulas, it is Friday after all! Today though we will discuss how to...
Category: Blog
Hello Excellers. Welcome back to another #MacroMonday blog post. Today let's look at how to create a simple Excel VBA Macro which will be useful for converting your data to uppercase on your...
Combine Conditional Formatting With An Excel Formula – Identifying Duplicate Values
Hello Excellers, welcome back to another blog in the #formulafriday series. Today let's look at how to combine conditional formatting with an Excel formula. What are we going to achieve...
Remove All Data Connections From An Excel Workbook Using VBA – Excel Macro
Hello, Excellers, welcome back to another #macromonday blog in this series. Glad to have you back. Today let's look at removing all data connections from an Excel workbook. Why would you want...
Conditional Formatting Excel Cell Text When A Formula Changes To A Typed Value- Formula Friday
Hello, Excellers welcome to today's #formulafriday blog post. Today let's look at using conditional formatting formula to change Excel cell text colour when a formula is replaced with a value. In...
How To Write A Macro To List All Files In A Folder – Macro Mondays
Hello, Excellers I am excited to share with you some cool VBA Macro fun. I find this a really useful macro which uses the Excel For Loop to list all files in a folder or directory. Similarly, we...