J
Josh Doten
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 "=$B3>9: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?
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 "=$B3>9: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?