Conditional Formatting Formula Rules

Conditional Formatting with Formula Rules There are several pre-defined options for highlighting ranges, Greater than, Less Than, Between… however if we want to define more than one criteria for highlighting cells, then you may want to define a Formatting Rule. For example you may have a spreadsheet of students which you would like to highlight […]

Excel Formulas A Beginners Guide

One of the most useful benefits Excel provides is a straight-forward way of calculating data. In the below example I will be demonstrating how to create a margin formula which will be recalculated on each row. By default formula calculations are set to automatic, however sometimes they can be switched off. To double-check they are turned on, in […]