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