I need help regarding conditional formatting a cell  according to the current
time. E.g. in cell A1 I have inserted the formula =now(). In A2 I need a
conditional format so that if the time in A2 is anywhere between the time in
A1 and an hour less from the time in A1 then it should be blue. However if
the time in A2 is anywhere between the time in A1 and an hour more from the
time in A1 then it should be red.

2/2/2007 22:44:49

2/2/2007 21:44:49