Conditional format based on other column in same table

Hi all,   I am trying to make the following table in Power BI, but for some reason it never yields the result im looking for.   Here below is the desired outcome (from Excel)   So i need to col...