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...
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...
An Excel Macro That Will Copy An Entire Worksheet To Another Workbook – Macro Mondays
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...
Identify New Customers With Conditional Formatting Using A Formula – Formula Friday
Hello Excellers and welcome back for aonther#formulafriday. Today I want to share how to highlight new entries into an Excel list within a specified time period. So, your boss has asked you send...