Forum Discussion
Conditional Format when value does not equal same row value in another column (Matrix)
Hi Bibiano_Geraldo / all I have a matrix which shows by country, which top product two different clients are using. E.g. Company A Company B UK APPLES ORANGES USA APPLES APP...
hi melimob1 ,
try to apply comditional formatting with measure like:
colormeasure =
VAR _b=
CALCULATE(
[measure],
data[country]="Country N"
)
RETURN
IF([measure]=_b, "red", "green")
more info
Hi, thank you for your response but I'm not sure I follow...
Does this mean I would have to list all my countries as I have lots?
Besides, it not really the country I am comparing (sorry just read my post and where I said 'column A' I meant 'Company A'. It's the products of that country row text to text columns under the company I want to compare?
not sure what measure I would need to add in where it states "Measure"? I need a measure formula to state, if Column x = column y value, then mark red.
Many thanks
Melissa