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...

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...

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...

Hello, Excellers welcome to another  #formulafriday  blog post with yet another an awesome Excel tip. No - one likes to be ignored right?....wrong?...let you decide that one, but I was asked...

Hi Excellers, welcome back to another instalment of #macromonday.  Let's look at how to save a tonne of time by writing a simple Excel VBA Macro that will copy an entire worksheet from one Excel...