WPF: Set a cell color based on other multiple values in other columns?

Question

I want to change the Abs(Diff) column. This has to be in Abs(Diff) because the viewer wants to see it this way.

 ID  | TYPE| CURRENT VALUE | TARGET       | ABS(Diff)
  1  | Sell| 10            |  11          | 1        --> Color Red
  2  | Sell| 11            |  10          | 1        --> Color Green
  3  | BUY | 10            |  9           | 1        --> Color Green
  4  | BUY | 10            |  11          | 1        --> Color Red

The meaning: Row 1: I have an item to sell. Current Market value is 10, I am looking to sell when it is at least(Target) 11. This does not meet my requirement. The color should be red in the cell for Abs(Diff)

I have looked at this. Change DataGrid cell colour based on values But this seems to be one value only. How do I look at multiple columns?

Sheridan · Accepted Answer · 2014-02-16T01:27:40.147

You could add a bool property named IsPositive that signifies whether the ABS(Diff) value is positive or negative. Maybe something like this:

public bool IsPositive
{
    get { return Diff >= 0; }
}

Then you'd need to do this to make sure that it updates in the UI when the Diff value changes:

public double Diff 
{
    get { return diff; }
    set
    {
        diff = value;
        NotifyPropertyChanged("Diff");
        NotifyPropertyChanged("IsPositive");
    }
}

Then you should be able to do something like this (adapted from the example in your linked question):

<DataGridTextColumn Binding="{Binding Abs}">
    <DataGridTextColumn.ElementStyle>
        <Style TargetType="{x:Type TextBlock}">
            <Style.Triggers>
                <DataTrigger Binding="{Binding IsPositive}" Value="True">
                    <Setter Property="Background" Value="LightGreen" />
                </DataTrigger>
                <DataTrigger Binding="{Binding IsPositive}" Value="False">
                    <Setter Property="Background" Value="Red" />
                </DataTrigger>
                <DataTrigger Binding="{Binding Abs}" Value="0">
                    <Setter Property="Background" Value="Black" />
                </DataTrigger>
            </Style.Triggers>
        </Style>
    </DataGridTextColumn.ElementStyle>
</DataGridTextColumn>

The second DataTrigger is when Value="False". Thanks I didn't know how to set up the xaml. — kay00, Feb 15 '14 at 01:59
Oh yeah, thanks for pointing that out, I'll update the code example. — Sheridan, Feb 16 '14 at 01:27

score 2 · Answer 2 · answered Feb 14 '14 at 21:50

2

But this seems to be one value only. How do I look at multiple columns?

If that's the 'only' problem, you should be creating another property in your ViewModel public bool ShouldColor, and have the desired logic there.

Or, you can achieve that by using MultiBinding

answered Feb 14 '14 at 21:50

Manish Basantani

16,931
22
71
103

If I set the ShouldColor column. How would Abs(Diff) color change color based the ShouldColor column? What is that in xaml? – kay00 Feb 14 '14 at 22:09
Multibinding in that example sets the value of the text. I still need to have the value to be 1. Is there a hidden value or something else I'm missing? – kay00 Feb 14 '14 at 22:12

WPF: Set a cell color based on other multiple values in other columns?

2 Answers2