Comparing Time in a Formula
 

I am trying to do some conditional formatting which requires me to compare
two "time" values".

Basically what I'm doing is changing the text color if the value of a cell,
which is formatted as a time of day, if that time is greater than 9:00 PM.

In the conditional format I tried "Use a Formula to determine which cells to
Format" with the formula "=$B39:00 PM" and several varients of the same
general idea. 90% of them returned errors, the other 10% made everything
true... even if it wasn't. The idea is that if B3's value were after 9:00 PM
the text would turn red.

Any idea what I'm doing wrong?

Comparing Time in a Formula
 

With that quote placement, you made the logic check a giant text string.
Try:
=$B3TIME(21,0,0)

--
Best Regards,

Luke M
"Josh Doten" wrote in message
...
I am trying to do some conditional formatting which requires me to compare
two "time" values".

Basically what I'm doing is changing the text color if the value of a
cell,
which is formatted as a time of day, if that time is greater than 9:00 PM.

In the conditional format I tried "Use a Formula to determine which cells
to
Format" with the formula "=$B39:00 PM" and several varients of the same
general idea. 90% of them returned errors, the other 10% made everything
true... even if it wasn't. The idea is that if B3's value were after 9:00
PM
the text would turn red.

Any idea what I'm doing wrong?