[DanDeCoder]

Guys, any reason why when the cell in the column 'sold' is set to 'No', the colour of the row still isn't changing to red?

Here's my code..

private void dataGridView1_CellFormatting(object sender, DataGridViewCellFormattingEventArgs e)
        {
            // Column is 'sold'
            // Looking to change all unsold vehicles to red

            if (this.dataGridView1.Columns[e.ColumnIndex].Name == "sold")
            {
                if (e.Value != null)
                {
                    string stringValue = (string)e.Value;
                    stringValue = stringValue.ToLower();

                    if (stringValue == "No")
                    {
                        e.CellStyle.BackColor = Color.Red;
                    }
                }
            }
        }

For info, I've tried changing the if statement to all variations of sold.. for example, _sold/Sold/sold. Still not working =(

[Sergio Tapia]

Try clicking on another cell and clicking back in. I just had this same problem with another event last night and I solved it by using the CellEndEdit event.

private void dataGridView1_CellEndEdit(object sender, DataGridViewCellEventArgs e)
{
    if (e.ColumnIndex > 1)
    {
        int tmpValue = Convert.ToInt32(dataGridView1[e.ColumnIndex, e.RowIndex].Value);

        if (tmpValue == 35)
        {
            dataGridView1[e.ColumnIndex, e.RowIndex].Style.BackColor = Color.Red;

        }
    }
}

[DanDeCoder]

Still not working have tried clicking out of the cell but still not changing to red. Could it be a property that needs changing perhaps?

[tlhIn`toq]

stringValue = stringValue.ToLower();

                    if (stringValue == "No")

Because you are setting stringValue to lower case then comparing it against a mixed case condition.

"no" will never equal "No"

[Sergio Tapia]

Hahaha didn't even check that! Good eye! That's probably what's causing your issue.

[eclipsed4utoo]

Change the code inside the if statement to this...

string value = Convert.ToString(e.Value);

if (value.Equals("No", StringComparison.InvariantCultureIgnoreCase))
{
    e.CellStyle.BackColor = Color.Red;
}

[DanDeCoder]

Trained eye I knew it was something easy, but didn't think it would be that simple!.. Anyhow, nice one guys!