Change excel row color

Not possible! LINQ is for data manipulation and not for format manipulation. When you read any data to datatable, the colors and fonts etc. cosmetic things don’t get read.

Use Format Cells activity to update the cell/range color in the excel. Another option use VBA macro. Only these two possible approaches.

1 Like