Free Support Forum -

Cumulative formatting

Is it possible to do cumulative formatting? For example, I want to individually format various cell font colours, then want the whole column to be bold AS WELL by applying a style to the column range. This seems to nullify all the individual cells’ formats and apply ONLY the bold for the column. Is there any way around this?

Please set whole column first then set individual cells.

Excel excel = new Excel();
Cells cells = excel.Worksheets[0].Cells;

cells.Columns[0].Style.Font.IsBold = true;

cells[0, 0].PutValue("hello");
cells[0, 0].Style.Font.Color = Color.Red;

cells[1, 0].PutValue("world");
cells[1, 0].Style.Font.Color = Color.Blue;