In this article I will explain with an example, how to change DataGridView Cell Color based on condition in Windows (WinForms) Application using C# and VB.Net.
Inside the CellFormatting event handler of the DataGridView, various conditions are used to compare the Cell value of the DataGridView Row and the Cell color of the DataGridView is changed based on the conditions holding true.
 
 
Form Design
The Form consists of a DataGridView control.
Change DataGridView Cell Color based on condition in Windows Application using C# and VB.Net
 
 
Populating the DataGridView
Inside the Form Load event handler, the DataGridView is populated with data by making use of a dynamic DataTable with some records.

C#
private void Form1_Load(object sender, EventArgs e)
{
    DataTable dt = new DataTable();
    dt.Columns.AddRange(new DataColumn[2] { new DataColumn("Item"), new DataColumn("Quantity") });
    dt.Rows.Add("Shirt", 145);
    dt.Rows.Add("Jeans", 0);
    dt.Rows.Add("Trousers", 190);
    dt.Rows.Add("Tie", 30);
    dt.Rows.Add("Cap", 0);
    dt.Rows.Add("Hat", 90);
    dt.Rows.Add("Scarf", 290);
    dt.Rows.Add("Belt", 150);
    dataGridView1.DataSource = dt;
    dataGridView1.AllowUserToAddRows = false;
}
 
VB.Net
Private Sub Form1_Load(sender As System.Object, e As System.EventArgs) Handles MyBase.Load
    Dim dt As DataTable = New DataTable
    dt.Columns.AddRange(New DataColumn() {New DataColumn("Item"), New DataColumn("Quantity")})
    dt.Rows.Add("Shirt", 145)
    dt.Rows.Add("Jeans", 0)
    dt.Rows.Add("Trousers", 190)
    dt.Rows.Add("Tie", 30)
    dt.Rows.Add("Cap", 0)
    dt.Rows.Add("Hat", 90)
    dt.Rows.Add("Scarf", 290)
    dt.Rows.Add("Belt", 150)
    dataGridView1.DataSource = dt
    dataGridView1.AllowUserToAddRows = False
End Sub
 
 
Change DataGridView Cell Color based on condition
Inside the CellFormatting event handler of the DataGridView, various conditions are used to compare the Cell value of the DataGridView Row and the Cell color of the DataGridView is changed based on the conditions holding true.
The following Table shows the different quantity values and the corresponding color of the DataGridView Cell.
Quantity Range
Background Color
0
RED
1 - 50
YELLOW
51 - 100
ORANGE
 

C#
private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
{
    //Compare the value of second Column i.e. Column with Index 1.
    if (e.ColumnIndex == 1 && e.Value != null)
    {
        //Fetch the value of the second Column.
        int quantity = Convert.ToInt32(e.Value);
 
        //Apply Background color based on value.
        if (quantity == 0)
        {
            e.CellStyle.BackColor.BackColor = Color.Red;
        }
        if (quantity > 0 && quantity <= 50)
        {
            e.CellStyle.BackColor.BackColor = Color.Yellow;
        }
        if (quantity > 50 && quantity <= 100)
        {
            e.CellStyle.BackColor = Color.Orange;
        }
    }
}
 
VB.Net
Private Sub dataGridView1_CellFormatting(sender As System.Object, e As System.Windows.Forms.DataGridViewCellFormattingEventArgs) Handles dataGridView1.CellFormatting
    'Compare the value of second Column i.e. Column with Index 1.
    If e.ColumnIndex = 1 AndAlso e.Value IsNot Nothing Then
 
        'Fetch the value of the second Column.
        Dim quantity As Integer = Convert.ToInt32(e.Value)
 
        'Apply Background color based on value.
        If quantity = 0 Then
            e.CellStyle.BackColor.BackColor = Color.Red
        End If
 
        If quantity > 0 AndAlso quantity <= 50 Then
            e.CellStyle.BackColor.BackColor = Color.Yellow
        End If
 
        If quantity > 50 AndAlso quantity <= 100 Then
            e.CellStyle.BackColor.BackColor = Color.Orange
        End If
    End If
End Sub
 
 
Screenshot
Change DataGridView Cell Color based on condition in Windows Application using C# and VB.Net
 
 
Downloads