Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm | Excel Discussion (Misc queries) | |||
HELP! I need to make an IF Statement comparing date/time fields.. | Excel Worksheet Functions | |||
comparing time value | Excel Discussion (Misc queries) | |||
Comparing time values which have milliseconds in them e.g 10:20:30 | Excel Discussion (Misc queries) | |||
comparing time intervals | Excel Worksheet Functions |