It's always useful if you tell us what's in your cells, what CF condition
you are trying to use, what result you're getting, and what result you
expected.

If you have times at 1 hour intervals, what's wrong with, CF/ Formula Is:
=HOUR(A1)=HOUR(NOW()) ?
--
David Biddulph

"Colin" wrote in message
...
In one row I have 24 cells, each cell representing 1 hour. I would like a
cell to change color, say from white to yellow, during the hour it
represents on the clock. I have tried conditional formatting with =HOUR,
Now() and =TIME without success.

I would greatly appreciate any assistance in solving this problem.

Colin