Automatically refresh a sheet every hour?

[Dave E]

Hi.

Not sure if this is possible... sure it will be... I have a workseet that is basically a massive list of orders that have been placed. I have some conditional formatting based on cells that use the today() function to work out how long (in days) since the order was placed.

Trouble is, the spreadsheet is always open, and is never closed down... so it does not refresh automatically. So orders that should go red to indicate a week since they've been placed, don't!

I don't want to rely on people refreshing the screen. Ideally, I would like it to refresh once a day at 1 minute past midnight, or even every hour...

???

Cheers for any help...

Dave

 

[Dave E]

Haha. Annoying isn't it!?

Ah well, if no-one else has any ideas, don't worry yourself unduly with it, its still working, it just means I'll get the message, which isn't the end of the world...

Thanks very much for your help...

Dave