Conditional Formatting Time

[DannyAlfa]

Hi all,

Hope you kind people can help with this, I have a table that I am trying to conditionally format based on time.

What I want it to do is show as red should the time be before 11pm and to show green if it is after 11pm (for the times in the centre column). Up to now all I have is a late flag measure to show 1 if the time is before 11pm, my plan was to then format the late flag measure based on the value.

You can see from the below screen shot what I have done up to now, any suggestions would be greatly appreciated.

[DannyAlfa]

@PhilipTreacy - in fact now I look at it its putting everything as red, which makes me think its something to do with how the time is formatted maybe????

[DannyAlfa]

@PhilipTreacy - Genius, worked a treat 🙂

[PhilipTreacy · Accepted solution]

Hi @DannyAlfa 

Download PBIX file with the example below

Create a measure

Time Colour = IF( SELECTEDVALUE('Till Data'[Time]) < TIMEVALUE("23:00"), "red", "green")

In the Conditional Formatting or the Time column use these settings

To give this

Regards

Phil