private void C_Formatting() { var lastrow_ = _rowNumber + 11; for (int columnNumber = 68; columnNumber < 99; columnNumber += 9) { Range range = _oSheet3.get_Range(GetCellIdColorCoding(columnNumber) + "11:" + GetCellIdColorCoding(columnNumber) + lastrow_); FormatCondition xStoresRed = range.FormatConditions.Add(XlFormatConditionType.xlCellValue, XlFormatConditionOperator.xlBetween, 1, 50); xStoresRed.Interior.Color = ColorTranslator.ToWin32(Color.Red); } }
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)