How to set the format of a column in excel using header name

Help StudioX
, , ,
1

image
Image above is my screenshot

i want to format a certain cell depending on the header of a column.
Please help… your response is highly appreciated regarding this matter

2

you can do that by using expression like

currentrow.byfield(“columnName”).Address

Regards

3

not working there’s an error …

4

HI,

Can you share what you want to achieve in details?

Regards,

5

if you provide the exact details it will be more helpful to provide the details

the expression will work if you are using in for each loop

can you provide the error as well how you want identify the cell address

Regards

6

Thanks for this one… Already figured out the solution… thanks for this expression.

7

Yoichi san,

well for additional details → I want to change the font color of the selected (header name) column using if condition…

in excel data
if Day is equal to Special Holiday then change font color of the new added column

because i am using macro in my excel file… sumbyfontcolor function…

8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.