Checkout OnTime in VBA help. It would be easy to run sometihing every hour
to do an Application.Calculate.
--
Gary''s Student - gsnu200738


"Sandy" wrote:

Hi
I have conditional formatting tied to the current hour. The spreadsheet may
not be updated evry hour. How can I refresh/recalc at the top of the hour so
that the conditional formatting changes?
Thanks