But when it comes to dates and times, you may have created some sort of tracking spreadsheet that needs to warn you once a certain date/ time is approaching. Is there a trick to auto refresh Excel every minute (with no VBA)?
A problem with the existing settings in Excel is that you cannot change more than 6 default chart colours. You can set up your own customised colours to use for each series but only up to series 6. This shows some workarounds.
Our 2018 Rugby Six Nations Predictions Spreadsheet enables up to 50 participants to predict the round robin and final winners (overall, grand slam, triple crown and wooden spoon) and compete to see who can be closest in predicting the overall result and the scores of each team.