Conditional Format Time Between 2 Cells

[rskip]

I would like to format cells in a list of times that have "expired" from the current time. I am using the function =Now() to get the "current" time. The current time cell is formatted to "hh:mm".
I would like to condition format the list of Session times to turn red as the current time pass's a time in the list. Times in the list are also formatted hh:mm.

Help Please !
Thank you

 

[SunnyAlv]

U can use "Conditional Formatting"
Like this

Step = Select All Data "Session Time"

Home --> Conditional Formatting --> Highlight Cells Rules --> Less Than (Shortcut : Alt + H + L + H + L)

And select Cell "B2" "Current Time"

 

[Fluff]

Another option.
Select C2 downwards & use this formula in CF

=AND(C2<>"",MOD(C2,1)<MOD($B$2,1))

 

[rskip]

Thanks Fuff, this is exactly what i was looking for, Cheers Mate, have a pint on me !

 

[Fluff]

You're welcome & thanks for the feedback.