Conditional Format for negative time
 

I'm attempting to format cells to recognize cells that are greater than minus
19 minutes (-0:19). So far, it won't work. I've tried using a ' before and
after the time but to no avail. Any suggestions?

Conditional Format for negative time
 

Use a formula of

=C1-TIME(0,19,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mailrail" wrote in message
...
I'm attempting to format cells to recognize cells that are greater than
minus
19 minutes (-0:19). So far, it won't work. I've tried using a ' before and
after the time but to no avail. Any suggestions?

Conditional Format for negative time
 

Thanks Bob but when I use that, it (like when I tried it one my own) formats
every single cell (whether less than the negative 19 minutes or not) with the
condition that I have used. I have to use the 1904 date system to get Excel
to recognize the negative time in the calculation. Is this causing a problem?

"Bob Phillips" wrote:

Use a formula of

=C1-TIME(0,19,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mailrail" wrote in message
...
I'm attempting to format cells to recognize cells that are greater than
minus
19 minutes (-0:19). So far, it won't work. I've tried using a ' before and
after the time but to no avail. Any suggestions?

Conditional Format for negative time
 

No, it works fine for me with 1904 date system as well.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mailrail" wrote in message
...
Thanks Bob but when I use that, it (like when I tried it one my own)
formats
every single cell (whether less than the negative 19 minutes or not) with
the
condition that I have used. I have to use the 1904 date system to get
Excel
to recognize the negative time in the calculation. Is this causing a
problem?

"Bob Phillips" wrote:

Use a formula of

=C1-TIME(0,19,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"mailrail" wrote in message
...
I'm attempting to format cells to recognize cells that are greater than
minus
19 minutes (-0:19). So far, it won't work. I've tried using a ' before
and
after the time but to no avail. Any suggestions?

Conditional Format for negative time
 

Sorry to be so dense, but do I type in your formula exactly as you've written
after I change the drop-down to "formula is" in the CF area? Remember...in my
cell, the value that I'm trying to format actually shows up (for instance) as
-0:23. Could that be causing a problem?

"Bob Phillips" wrote:

No, it works fine for me with 1904 date system as well.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mailrail" wrote in message
...
Thanks Bob but when I use that, it (like when I tried it one my own)
formats
every single cell (whether less than the negative 19 minutes or not) with
the
condition that I have used. I have to use the 1904 date system to get
Excel
to recognize the negative time in the calculation. Is this causing a
problem?

"Bob Phillips" wrote:

Use a formula of

=C1-TIME(0,19,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"mailrail" wrote in message
...
I'm attempting to format cells to recognize cells that are greater than
minus
19 minutes (-0:19). So far, it won't work. I've tried using a ' before
and
after the time but to no avail. Any suggestions?

Conditional Format for negative time
 

Yes you do, but the way I have written it assumes that the selected cell, or
the first of the selected cells, is C1. If not change the formula
accordingly.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mailrail" wrote in message
...
Sorry to be so dense, but do I type in your formula exactly as you've
written
after I change the drop-down to "formula is" in the CF area? Remember...in
my
cell, the value that I'm trying to format actually shows up (for instance)
as
-0:23. Could that be causing a problem?

"Bob Phillips" wrote:

No, it works fine for me with 1904 date system as well.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"mailrail" wrote in message
...
Thanks Bob but when I use that, it (like when I tried it one my own)
formats
every single cell (whether less than the negative 19 minutes or not)
with
the
condition that I have used. I have to use the 1904 date system to get
Excel
to recognize the negative time in the calculation. Is this causing a
problem?

"Bob Phillips" wrote:

Use a formula of

=C1-TIME(0,19,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"mailrail" wrote in message
...
I'm attempting to format cells to recognize cells that are greater
than
minus
19 minutes (-0:19). So far, it won't work. I've tried using a '
before
and
after the time but to no avail. Any suggestions?

Conditional Format for negative time
 

That did it. Thanks for putting up with me today Bob.

"Bob Phillips" wrote:

Yes you do, but the way I have written it assumes that the selected cell, or
the first of the selected cells, is C1. If not change the formula
accordingly.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"mailrail" wrote in message
...
Sorry to be so dense, but do I type in your formula exactly as you've
written
after I change the drop-down to "formula is" in the CF area? Remember...in
my
cell, the value that I'm trying to format actually shows up (for instance)
as
-0:23. Could that be causing a problem?

"Bob Phillips" wrote:

No, it works fine for me with 1904 date system as well.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"mailrail" wrote in message
...
Thanks Bob but when I use that, it (like when I tried it one my own)
formats
every single cell (whether less than the negative 19 minutes or not)
with
the
condition that I have used. I have to use the 1904 date system to get
Excel
to recognize the negative time in the calculation. Is this causing a
problem?

"Bob Phillips" wrote:

Use a formula of

=C1-TIME(0,19,0)

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"mailrail" wrote in message
...
I'm attempting to format cells to recognize cells that are greater
than
minus
19 minutes (-0:19). So far, it won't work. I've tried using a '
before
and
after the time but to no avail. Any suggestions?