compare two dataGridView cell with date value?

Question

in my c# windows form i have a dataGridView that loads the data from a table The dataGridView has 8 columns two of them have date value borrow_date and return_date . I want to compare the of that two columns if the date of any return_date cell is greater that the date of borrow_date cell make the background of that cell red or make it's fore color red.

Vulpes · Answer

Try something like this: foreach (DataGridViewRow row in dataGridView1.Rows) { if (row.IsNewRow) break; if ((DateTime)row.Cells[borrow_date].Value { row.Cells[return_date].Style.BackColor = Color.Red; } }