Set Range Color

[Nenna_Anya]

Is there anyway to set the background color of a header cells for a workbook containing several sheets with headers that all need to be formatted green. I am using the set range color activity.

[ushu (Usha kiranmai)]

@Nenna_Anya You can also try with vb code,macros, balareva activities (Balareva.easy excel.activities)

[fernando_zuluaga]

can you try using th read range without addheaders propertie activated, then get the last column with data with dt.ColumnCount then pass the range to set color activity, from A to the last number

[nikhil.girish]

Hi @Nenna_Anya

Kindly refer below link

Fill Excel Cell Color UiPath | Set Range Color UiPath | Excel Automation UiPath RPA

Thanks