Cell A1:A24 = 1-24 CF Cell value = HOUR(NOW())

"SysAccountant" wrote:

Sandy

When you say "tied to the hour" ; how did you achieve this.


SysAccountant

"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