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 

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" <colin.gough@gmail.com> wrote in message 
news:062C1B79-E21E-4AB6-9D22-2D6B2F3569C1@microsoft.com...
> 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 

Another option is / Cell value is:
 =TIME(HOUR(NOW()),,)
--
David Biddulph

"David Biddulph" <groups [at] biddulph.org.uk> wrote in message 
news:OpydnbwxHpYJKpLWnZ2dnUVZ8kGdnZ2d@bt.com...
> 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" <colin.gough@gmail.com> wrote in message 
> news:062C1B79-E21E-4AB6-9D22-2D6B2F3569C1@microsoft.com...
>> 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
>
> 

1. Select the cell/Range (say A1:X1). Please note that the cell reference A1 
mentioned in the formula is the active cell in the selection. Active cell 
will have a white background even after selection
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
'if values from A1 to X1 are entered as 1,2,3,....24 then
=A1=VALUE(TEXT(NOW(),"hh"))

OR if values are entered in time format 1:00 AM, 2:00 AM etc; then try
=TEXT(A1,"hh")=TEXT(NOW(),"hh")

4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

PS: If you are using XL2007 Goto Home tab>Styles>Conditional 
Formatting>Manage rules>New rule>Use a formula to determine which cells to 
format. Enter the formula in the box below.

If this post helps click Yes
---------------
Jacob Skaria


"Colin" wrote:

> 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 
> 

Sorry for lack of detail. In my SS cells B17 to Y17 are number 0 to 23, 
representing 24 hours.  Directly below each row 17 cell is a blank/empty 
cell.  During the period midnight to 1am I would like only cell B18 to have 
a yellow fill, then during the period 1am to 2 am I would like only cell C18 
to have a yellow fill and so on for the full 24 hours after which the 
colored cell returns to the beginning and starts the process again.

Colin

"Colin" <colin.gough@gmail.com> wrote in message 
news:062C1B79-E21E-4AB6-9D22-2D6B2F3569C1@microsoft.com...
> 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 

Try a CF of:
=B$17=hour(now())

Regards,
Fred.

"Colin" <colin.gough@gmail.com> wrote in message 
news:79C962F7-E5FD-42B7-945D-45D5A3195D89@microsoft.com...
> Sorry for lack of detail. In my SS cells B17 to Y17 are number 0 to 23, 
> representing 24 hours.  Directly below each row 17 cell is a blank/empty 
> cell.  During the period midnight to 1am I would like only cell B18 to 
> have a yellow fill, then during the period 1am to 2 am I would like only 
> cell C18 to have a yellow fill and so on for the full 24 hours after which 
> the colored cell returns to the beginning and starts the process again.
>
> Colin
>
> "Colin" <colin.gough@gmail.com> wrote in message 
> news:062C1B79-E21E-4AB6-9D22-2D6B2F3569C1@microsoft.com...
>> 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
> 

1. Select the cell/Range (say B18:X18). Please note that the active cell in 
the selection should be B18. Active cell will have a white background even 
after selection
2. From menu Format>Conditional Formatting>
3. For Condition1>Select 'Formula Is' and enter the below formula
=B17=HOUR(NOW())

4. Click Format Button>Pattern and select your color (say Red)
5. Hit OK

If this post helps click Yes
---------------
Jacob Skaria


"Colin" wrote:

> Sorry for lack of detail. In my SS cells B17 to Y17 are number 0 to 23, 
> representing 24 hours.  Directly below each row 17 cell is a blank/empty 
> cell.  During the period midnight to 1am I would like only cell B18 to have 
> a yellow fill, then during the period 1am to 2 am I would like only cell C18 
> to have a yellow fill and so on for the full 24 hours after which the 
> colored cell returns to the beginning and starts the process again.
> 
> Colin
> 
> "Colin" <colin.gough@gmail.com> wrote in message 
> news:062C1B79-E21E-4AB6-9D22-2D6B2F3569C1@microsoft.com...
> > 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 
>