Visually analyse data with Conditional Formatting

Applying conditional formatting allows you to change the format of the cells in your spreadsheet, depending on certain conditions. For example, you could highlight cells in a particular colour when the numbers in those cells match a certain value. This is set using a type of conditional formatting, “Highlight Cells Rules”. Types of conditional formatting...

Logical functions

There are several logical functions in Excel. This guide provides details of the 3 most common logical functions: IF - used to return one value if the result of a test is true and another value if the result of a test is false. AND - used in conjunction with the IF function to allow multiple tests to be performed, then returning one value if ALL the results of the tests are true and another value if the results of ALL the tests are false. OR - used in conjunction with the IF function to allow multiple tests to be performed, then returning one value if ANY of the results of the tests are true and another value if the results of ANY of the tests are false.