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.

You're busy and maybe you're lazy and that desktop has turned into a junk yard of files. But what if you want to create a good impression -then get some housework done and file them away correctly - or you could just brush those files under the carpet until you have time to sort them!

How to write a fabulous Copilot prompt!