Hi all

I am setting up a draw for a competition, and want to make it as easy as possible for the people to read.

To assist in this, i want to highlight any rounds in the draw that have already been started, therefore directing their eyes to the next round to be played. To achieve this, i am just using a conditional format to change the background colour once the Now() time is past the start time of that round.

My issue is that unless i manually change something on the sheet, the formula =now() does not refresh.

It could be an extended period between making changes, so i want to get it to refresh every 5 minutes, that way if the start time for a round has passed it will highlight.

Is there a function to force the sheet to refresh periodically?

Thanks in advance

Darren.