LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
HELP! IF Statements Comparing Date/Time Entries (yyyy-mm-dd hh:mm Ksoloway Excel Discussion (Misc queries) 1 November 5th 09 02:56 AM
HELP! I need to make an IF Statement comparing date/time fields.. Ksoloway Excel Worksheet Functions 2 November 4th 09 04:41 PM
comparing time value ml Excel Discussion (Misc queries) 4 March 18th 09 10:16 PM
Comparing time values which have milliseconds in them e.g 10:20:30 Jon Stickings Excel Discussion (Misc queries) 5 October 5th 06 02:03 PM
comparing time intervals znaya Excel Worksheet Functions 0 May 8th 06 06:47 PM


All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"