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...
Tag: Excel Tips
Hello, Excellers. Today's blog post is a coffee break quick Excel tip for you. So, I was recently asked how to make Excel worksheet tabs stand out by changing their tab colour. In particular,...
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...
Formula Friday- Increase Or Decrease A Number By A Percentage In Excel
Hello, Excellers it is yet another week has gone by which means it's time for Formula Friday Excel tip. Let's take a look at percentages today and specifically increasing or decreasing a number...
Highlight Misspelled Words In Excel With A Simple VBA Macro – Macro Mondays
Hello and welcome to your weekly instalment of #macromonday. A great way to learn how to write Excel VBA macros. Today we will let's look at mistakes, or being more specific misspelled words. ...
A VBA Excel Macro Which Will Export And Save Each Worksheet As A Separate PDF – Macro Mondays
Hello Excellers and welcome back to my regular blog spot of #macromonday. Today, I want to show you how to write a simple Excel VBA macro which will convert to PDF then export and save each of...