View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Waitsu Waitsu is offline
external usenet poster
 
Posts: 2
Default Time - How do you see if a time value is between 2 values?

I want to perform a conditional formating in Excel that says:

If the time is between 07:00 and 13:59 then turn the cell border red and
turn the font red.

if the time is between 14:00 and 07:00 turn the cell green.
Condition 1
This works to turn the cell green: =$F$4<=$E$4

Condition 2
This works to change the font red: =$F$4=$E$4

Condition 3
This does not turn the cell green: =$F$4TIME(14,0,0)


Does anyone have any idea on how can I code this so that it will work?

Thanks