How to use Custom Formats to change the colour of the cell, display an emoji or add text depending on the cell's contents.

Whilst you can use conditional formatting and cell fill etc. to give you almost any colour in excel there is a "special" set of 56...

It is not possible to directly access the colour of a cell in an Excel worksheet. Thus you can not write an expression such as “if the...

Sometimes in Excel you want to make a selection dependent on another choice. For instance, you would like to select a country from a...

Situation A client had a single worksheet per project and wanted to pull data from each sheet into a single dashboard to give a view...

10 more ways to make MS Project work for you. How to be more efficient and harness the power of MS Project

In this blog you will learn how to filter a project or programme plan to show the tasks ahead which have been assignefd to a specific...

How to use VBA to get the RGB colour for a cell and then adjust this colour by changing the shade or tint. Then colour another cell.

Ten easy hints and tips to help you be faster and more efficient when using Microsoft Project.