Formula needed for conditional formatting between time range over 2 columns

**index9** · 07-19-2016, 11:27 PM

Hi all,

I have sat on this for a day now googling has not been successful and could really use your expertise in tweaking the formula. I'm trying to apply conditional formatting to 2 columns if the time falls between assigned times.

This formula is only partially working and is not picking up all times between 10:45-11:30.

=AND ($K2> TIME(10,4,5), $L2 < TIME(11,3,0)) - there are spaces in between because Scuri detects it's a HTML and won't allow me to post this thread

Example: So in the below list, K2:L2, K3:L3 would be highlighted but K1:L1 and K4:L4 does not because it falls outside of specified conditions of 10:45 - 11:30.
Column K Column L
1 10:15 10:30
2 10:45 11:15
3 11:00 11:30
4 11:15 11:50

Thanks in advance

**Crooza** · 07-19-2016, 11:41 PM

The time function is Hours, minutes, seconds. If you want 10:45 I would change time(10,4,5) to time(10,45,0) and likelwise for 11:30 time (11,30,0)

**JeteMc** · 07-19-2016, 11:41 PM

Try this conditional formatting rule:

Formula:

=AND($K1>=TIME(10,45,0),$L1<=TIME(11,30,0))

Note: you can delete M1:M4
Let me know if you have any questions.

**index9** · 07-20-2016, 12:01 AM

Thanks so much Crooza and JeteMc (thanks for going the extra mile with providing an example)

**JeteMc** · 07-20-2016, 08:26 AM

You're Welcome and thank you for the feedback. Please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a blessed day.