Conditional for Negative number and Negative Percentage in a single measure

[likhitha2705]

Hello All,
        I've created a table by manually entering the Data as Sales and Gross Margin as rows.
And I wrote a DAX like this

Test =

IF(SELECTEDVALUE('Table'[Column1])="Sales",[TotalSales],

IF(SELECTEDVALUE('Table'[Column1])="Gross Margin",FORMAT([Gross Rev.Margin],"Percent")))

Now I want to do Conditional Foormatting for the above measure.The Condition is as follows 
If([Test] <0 ,"Red","Green")

With the above measure the conditional Formatting is effecting only Sales(It's currency Value) but not the Gross Margin.(it's in Percentage)
Is there any way to achieve this?
TIA

[ray_aramburo]

I would recommend to separate your measures or even the columns. The moment you format the percentage one it turns into text and you lose the ability to evaluate with numerical logic. So, create a separate column that formats it as text and use the numerical one to evaluate the logic.