Click here to Skip to main content
14,828,337 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have one data-grid view which is bind dynamically. and it contain data like below screen shot.

Image Link[^]

Now problem is i want change cell color based on data value. i want to deduct tamount-paymentamont and if it >=1 then i want to set this two cell color as a red and other as every new data bind.
Updated 18-Sep-13 20:48pm

1 solution

i try this and it work for me..

for (int n = 0; n < (dataGridView1.Rows.Count - 1); n++)
                    double i = Convert.ToDouble(dataGridView1.Rows[n].Cells["tamount"].Value.ToString().Replace('.', ','));
                    double j = Convert.ToDouble(dataGridView1.Rows[n].Cells["paymentamount"].Value.ToString().Replace('.', ','));
                    double total = i - j;
                    if (total >= 1)
                        dataGridView1.Rows[n].Cells["tamount"].Style.BackColor = Color.LightPink;
                        dataGridView1.Rows[n].Cells["paymentamount"].Style.BackColor = Color.LightPink;

                        dataGridView1.Rows[n].Cells["tamount"].Style.BackColor = Color.LightGreen;
                        dataGridView1.Rows[n].Cells["paymentamount"].Style.BackColor = Color.LightGreen;


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900