View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Christopher Jack Christopher Jack is offline
external usenet poster
 
Posts: 5
Default Conditional Formatting not working right

For anyone who read this, I figured out a way that works. In my calculated entries, I added an extra 30 seconds so that the conditional formatting works when the "times" are the same.

e.g. e2-"03:00" + "00:00:30"

~~Chris