private void updateMainDGVs(List <double> redZoneScores) { foreach (DataGridView d in mainScreenDGVs) { d.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells; d.AutoResizeColumns(); foreach (DataGridViewColumn column in d.Columns) { if (column.Name.Contains("Avg") || column.Name.Contains("Score")) { column.DefaultCellStyle.Format = "n2"; column.ValueType = typeof(double); } d.Columns[column.Name].SortMode = DataGridViewColumnSortMode.Automatic; } double maxRZS = redZoneScores.Max(); double minRZS = redZoneScores.Min(); double rzsRange = maxRZS - minRZS; float maxColorCorrectionFactor = 1.0f; foreach (DataGridViewRow row in d.Rows) { double rzs = Convert.ToDouble(row.Cells["RedZoneScore"].Value); if (rzs > 1) { float correctionFactor = 0f; correctionFactor = (float)((maxRZS - rzs) / rzsRange) * maxColorCorrectionFactor; row.DefaultCellStyle.BackColor = HelperDataStructures.ligtenColor(Color.LightBlue, correctionFactor); } } //d.Sort(d.Columns["RedZoneScore"], ListSortDirection.Descending); } }