Conditional Format Two Dates

[Morendo1975]

Good Evening!  I'm working on a matrix module and have two date columns that contain when the members evaluation is due and another column that shows the current evaluation date in the record.  I would like to create some type of conditional format that turns the cell Red if dates do not match.

Appreciate the help!

[danextian · Accepted solution]

Hi @Morendo1975 

Try this:

Conditional Format =
IF (
    SELECTEDVALUE ( 'Table'[Date1] ) <> SELECTEDVALUE ( 'Table'[Date2] ),
    "Red"
)

Please note that conditional formatting in Matrix applies to values only - not column or row headers.