Conditional formatting

[Ragnarock1982]

Happy new year datanuts!

I have a question...

When using a matrix, is it possible to have conditional formatting based on values in two columns? I'll try my best to explain...

For example:

Row column    Value 1    Value 2

Row 1               10            11

Row 2               9              12

Row 3               15            30

I would like the 'Value 1' of 'Row 2'  ..  (9).. to show in red, as the actual value is lower than the 'Value 2' of that same row.

I tried using the conditional formatting option, but could not find a way for it to work.

Thanks,

[AnkitBI · Accepted solution]

@Ragnarock1982 

One Way to do is to create a calculated column using below formaula. This will return 1,0,-1 based on positve, zero and negative result. Then use this column for Conditional Formatting using Rules.

Do share complete data if it doesn't work or your requirement is different.

Column = sign(Table5[Value2] - Table5[Value1])

 Regards
AJ
Do Like Post if response seems good and Worth liking.
Do Mark as Solution if response resolved your Issue.

[Ragnarock1982]

Perfect!

Exactly what I needed.