Conditional Formatting based on table

[Anonymous]

Hey everyone,

I've got the following table:

I'd like to format the first two columns conditionally:
If the of Totaal Omzet is less then Prognose Omzet, then the value should be red. Otherwise green.

Is there a way to do this?

With kind regards,

Lazzanova

[Saap · Accepted solution]

Hi @Anonymous 

You can create simple measure to check if prognose is higher than total:

check = IF(SUM('Table new'[Prognose])>SUM('Table new'[Total]),1,0)

Then you go to matrix's visual settings, cell elements and apply background color based on your measure: