private void LoadGrid() { ViewRepository repository = new ViewRepository(); var gridItems = repository.GetNotWorking().Where(e => e.Month == GlobalValues.Instance.CurrentMonth).ToList(); dataGridView1.DataSource = gridItems; dataGridView1.Columns[2].Visible = false; dataGridView1.Columns[8].Visible = false; dataGridView1.Columns[7].Visible = fiveweek; for (int i = 0; i < gridItems.Count; i++) { if (gridItems[i].Week1 == 0) { dataGridView1.Rows[i].Cells[3].Style.BackColor = Color.Red; } if (gridItems[i].Week2 == 0) { dataGridView1.Rows[i].Cells[4].Style.BackColor = Color.Red; } if (gridItems[i].Week3 == 0) { dataGridView1.Rows[i].Cells[5].Style.BackColor = Color.Red; } if (gridItems[i].Week4 == 0) { dataGridView1.Rows[i].Cells[6].Style.BackColor = Color.Red; } if (gridItems[i].Week5 == 0) { dataGridView1.Rows[i].Cells[7].Style.BackColor = Color.Red; } } }