undefined

[akhassim]

I have the following table. I need to highlight the dates red if it is in the past and the status open. If status is closed, or date is in the future. It stays black. Please help. 

Due date	Status
2023/09/04	Closed
2023/08/01	Open
2023/09/08	Open
2024/01/04	Open

[Idrissshatila · Accepted solution]

Hello @akhassim ,

First create the following measure 

Date color = 
Var selected = SELECTEDVALUE('Table'[Start date]) 
return
IF( selected> TODAY() && SELECTEDVALUE('Table'[Status]) = "Open", " Red" )

Then go to the date field and select conditional formatting and select font color 

then select format style as field value and date color measure 

and this is the result

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡