Conditional formatting on a gridView

Question

I have a gridView where it’s loaded, from my SQLServer, all bank information.

My question is this. can change the color of the source when a date is less than the date of the system (for example, put in red the accounts that are past due)?

Follow my code to load the gridView and the screen:

private void CarregarGridContasPagarAberto()
{

    IList<ContasPagarDTO> listaContasPagar = new List<ContasPagarDTO>();
    listaContasPagar = new ContasPagarModel().CargaContasPagarAberto();

    dgvContasPagar.AutoGenerateColumns = false;
    dgvContasPagar.DataSource = listaContasPagar;
}

screen:

private void dgvContasPagar_CellFormatting(object sender, DataGridViewCellFormattingEventArgs Arguments)
{
    IList<ContasPagarDTO> listaContasPagar = new List<ContasPagarDTO>();
    listaContasPagar = new ContasPagarModel().CargaContasPagarAberto();

    if (this.dgvContasPagar.Columns[Arguments.ColumnIndex].Name == "DtVencContas")
    {
       // return;

       var Conta = listaContasPagar[Arguments.RowIndex];

       if(Conta.DtVencContas < DateTime.Now)
           Arguments.CellStyle.ForeColor = Color.Red;
       else
           Arguments.CellStyle.ForeColor = Color.Black;
    }
}

Answer 1

Use the Cellformating event.

private void DataGridView1_CellFormatting (object Sender, DataGridViewCellFormattingEventArgs Arguments)
{
    if (this.DataGridView1.Columns [Arguments.ColumnIndex].Name != "Sua Coluna Aqui")
        return;

    var Conta = ListaContasPagar [Arguments.RowIndex];

    if (DateTime.Now < Conta.DataDaConta)
        Arguments.CellStyle.BackColor = Color.Green;
    else
        Arguments.CellStyle.BackColor = Color.Red;
}