Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting date/time serial values to cumulative time totals... | Excel Discussion (Misc queries) | |||
Fun with Time values | Excel Discussion (Misc queries) | |||
Calculating days & time left from start date/time to end date/time | Excel Worksheet Functions | |||
how do i sum up a column of time values but ignore negative values | New Users to Excel | |||
need help with - time values... | Excel Discussion (Misc queries) |