Time values for conditional formatting, Kindly help me!

[Ayyappa5678]

Hi team,

Good Evening!

I have the time values with "00:00" format in table visual(like below snapshot). I need to do conditional formatting like

a) 00:00 to 01:59 with no background color, leave it as it is.

b) 02:00 and remaining all values need to change with background color is red.

Kindly help me please!
Thanks in advance.

[Ayyappa5678 · Accepted solution]

HighlightTime =
VAR _time = SELECTEDVALUE(Gap[gap])
VAR _timeValue = TIMEVALUE(_time)
VAR _highlight =
IF(
_timeValue >= TIME(0,0,0) && _timeValue < TIME(2,0,0),
0, // no color
1 // red color
)
RETURN _highlight

[Ayyappa5678]

Kindly please respond. @Y_S 
@Anonymous 

[Y_S]

You can create a simple measure, setting highlight to yes/no, then do conditional formatting:

HighlightTime =

 var _time = SELECTEDVALUE('Table'[Column1])

 var _highlight =

    IF(

        _time >= TIME(0,0,0) && _time < TIME(2,0,0)  ,

        0, // no color

        1 // red color

    )

return _highlight

[Ayyappa5678]

Thanks for the response,

But currently my exiting time column is with text format. 

While doing all the measures and all getting below snapshot error. Kindly please check and do needful pls.

Thanks in advance.