Start by selecting a column of dates. Click conditional formatting. Highlight Cell Rules. Click A Date Occurring. Now choose your Date Occurring and Format Colour.

Microsoft Word is turning 40 and here is our favourite trick to celebrate! Here is how to quickly format text in Microsoft Word. Selecting the Text with Similar Formatting can be made easy, especially handy when you want to change all the headings in a document to a different style, switch a certain font size or even change a footer or header. This can be done by selecting the text in your document that has the formatting you want to change. On the Home tab, click the Editing Group button, Select and Select All with Similar Formatting. Apply a different style or change the formatting for the selected text.

Find the number of days between dates. The conversion from kgs to grams, how many megabytes in a terabyte and so much more!