conditional formatting using clock time
Might be a good idea to test for a time entry:
=AND(ISNUMBER(A1),OR(A1=TIME(15,0,0),A1<=TIME(5,5 9,0)))
Biff
"Teethless mama" wrote in message
...
Conditional Formatting
=OR(A1=TIME(15,0,0),A1<=TIME(5,59,0))
"Merna" wrote:
How can I highlight the entire row based on the value of column "E" when
column "E" is a TIME based on the 24hr clock. I need rows with a the
time in
column "E" between 3:00 pm (15:00) and 5:59 am (05:59) (evening/night
shift)
to be shaded. But I do not want times between 6:00 am (06:00) and 2:59
pm
(14:59) (day shift) to be shaded.
Any help will be appreciated.
|