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

Happy Friday and time for some more #formulafun on a Friday!.  I recently was asked to find a way of knowing how many errors ( if any) were in an Excel worksheet.  I came across this quick and easy...

It sometimes it is really useful to show your Excel formulas on your worksheets.  This gives an insight into the logic of the worksheet.  It also is a great way to check your formulas to ensure...

Hi Excellers. Today it is time for some more formula fun.  Here is one way to display percentages and numbers together in one column that are currently stored in separate columns on a worksheet,...

Excel formulas can be daunting, I know that - even if you have been been using excel for years, the formula part can be scary. The many text books on offer or courses really do get complicated...

Hello Excellers time for more #formulafriday fun. Ever need to know how much you need to score on your last assessment to reach your target score so you know exactly how far away you really are...