date: expiry, plan date conditional formatting

[JJbc23]

Hi,

Would like to seek help on condidtional formatting. 
I have a table with two fields, expiry date and planned date(the date to perform the renewal). 
Would like to have a conditional formatting of, 
if planned date is greater than today and expiry date is greater than today, mark the cell red

Thanks

[Anonymous · Accepted solution]

Hi @JJbc23 

Based on your needs, I have created the following table.

You can use the following dax to decide if you want to display it in red.

Highlight = IF(AND('Table'[plan date] > TODAY(), 'Table'[end date] > TODAY()), "True", "False")

Then apply the appropriate rule to this column in the formatting

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.