Conditional Formatting based on time

[Unicorn_Tech]

Apologies if this is a duplicate post.

I would like to set up conditional formatting, comparing one value in a column to another value in a column (for the same row.)  I want to know if Monthly Average Time on a Page is larger than the Yeary Average Time on a Page.

Sample table:

Page	Monthly Average	Yearly Average
Home Page	01:32	01:28
about Page	00:52	01:20

Ideally, for the above table, the Monthly Average for "Home Page" would be bold, and the Yearly Average for "About Page" would be bold.

This is more complicated because this is a time value.  I'm assuming I would have better luck using the raw decimal data to do the comparison of greater than?  The above is correct, but it's formatted to show a correct value.

[negi007 · Accepted solution]

@Unicorn_Tech  Can you please try doing it below if helps you.

Change the time value to below

then create one measure like 

Check = if (SUM(Page[Yearly Average])>SUM(Page[Monthly Average]),1,0)

then set the rules like below for both monthly average and Yearly Average

below is the ouput

[Unicorn_Tech]

Thank you so much!