Question
4
Replies
764
Views
Cigna Corporation
Posted: October 30, 2018
Last activity: November 15, 2018
Closed
How to format specific excel row/column?
Hi Community,
I have to change the color of a row based on the particular cell value in that row.
I could get excel range following the steps provided in the post Excel-How to .I tried as guided in Formatting text . But this is resulting with coloring the entire sheet because the range is entire excel used range.
Is there any way to change the color/ font of particular cell or row or column. Could anyone please help on this.
Thanks,
In build 8.0 SP1 2010 which will be released shortly you will have a method called RangeSetBackgroundColor. In conjunction with WorksheetGetRange you should be able to do what you want. Here is an example:
In this release there are over 40 new methods on the Excel connector.