What you didn’t know about the Format Painter

Format Painter is a great tool, it can be used in any of the Office Applications, it allows you to copy formatting from one area/object to another, but did you know that’s only half of what it’s capable of? What if you need to copy formatting to more than...

Conditional Formatting and Dropdown Menus

How to create a menu of options that when selected will change the colour of the cell. For example, selecting Cancelled from a list should change the cell background colour to red to indicate clearly to the user that the project or course etc. has not been given the...