Conditonal Formatting Duration Help.

[stateofazzie]

Hello I am having trouble getting the right condition format to highlight a color based off duration. 

Idea is say for example if the talk time is greater than 15 minutes, it should highlight yellow. Thanks for the help on this!

[amitchandak]

@stateofazzie , Create a color measure and use that in conditional formatting using filed value option

if( [Avg talk time] > time(15,0,0), "yellow", "white")

How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4

[stateofazzie · Accepted solution]

Thanks for the response. I was able to do it  with

= IF(([Average Handle time])>TIMEVALUE("00:15:00"),1,0) which made columns on the table and from there I was able to plot the colors using the built in formatting tool.