Conditional formatting using now() function Excel 2003

Hi all,
I have a simple bus timetable and I wish to conditionally format all the cells based on the system time. Ideally, any cell that contains a value that is greater than or equal to the current time, and less than or equal to the current time plus 1 hour needs to be formatted differently to the rest. (i.e. only buses due in the next hour will be formatted). I have enclosed a sample if neccessary - the current time is in cell A1. Thank you.

Change the formula in A1 to
=MOD(NOW(),1)
This makes it a time only value, instead of Date+Time.

Then select A3:AV76 and use "Formula Is" in conditional formatting
=AND(A3>=$A$1,A3<=$A$1+"01:00:00")

Thanks Jonmo1 - I'll try it now and let you know if it works in about half hour. I'm sure it will

Yep - that's exactly what I wanted. thanks very much again Jonmo1.

You're welcome.