Condition Background Colour On Straight Table Date Cell

[rebelfox]

I have a contract table which includes the fields:-

[Contract Start Date]
[Contract Duration In Months]
[Contract Status]

I want to list the columns in a straight table and then add one more column
showing  the date the contract should expire. 
This is calculated as:-  addmonths (Contract_Start_Date, Contract_Duration_in_Months)
as Contract_Expire_Date  on the table load.

However…I would like the straight table to highlight the Contract_Expire_Date background
in red if the Contract_Expire_Date has passed current date ( i.e. Contract_Expire_Date < Today() ).

However I’m not sure how to do that.
There is the ‘Visual Cues’ tab with an ‘Upper’ and ‘Lower’ option but I’m not
clear how to code this as an expression that would work.  Is there another way?

Guidance would be appreciated.

[MK_QSL · Accepted solution]

Click on + sign on your Contract_Expire_Date or any other expression you have used.

Write below in Background color expression

IF(AddMonths([Contract Start Date],[Contract Duration In Months]) <= Today(), RED())

[rebelfox]

Yuop that did it.

Thanks.

So much to learn.....