Quickest way to change formatting of rows based on condition

[hsendel]

Dears,

I need to color rows text based on one condition, I use Change formatting activity but it takes too much time for each row, is there any alternative option to make execution faster ?

Thanks in advance

[Palaniyappan (Forum Leader)]

Hi

Did we try with this activity

Set Range Color

Cheers @hsendel

[hsendel]

Thanks @Palaniyappan , This Activity will color the cell itself, I want to color Text Only.

[Palaniyappan (Forum Leader)]

Hope this could help you in terms of vb

How to change the font color in the excel cell

Hello fellows, @supermanPunch @AndersJensen @NIVED_NAMBIAR Here I want to change the cell font color black to red. Here is the workflow [image] I’m writing “C” in the excel cell. I want to write it in the Red color on the excel sheet How can we do this? Thanks in advanced

Cheers @hsendel

[hsendel]

Thanks @Palaniyappan , I got the following :

And also is there a way to have this VBS file inside and invoke activity, I don’t want to have extra files in my folder ( If possible)

[Palaniyappan (Forum Leader)]

It’s something with the file access
Open the excel file and click file → options and trust Center

Check for this
Thread

Error: Invoke VBA: Programmatic access to Visual Basic Project is not trusted

@CristinaAlina have a Look in this Then Focus on the settings from the Excel Activity e.g Excel Application scope Macros enablement

Hmm when it comes to excel file it’s good to have invoke VBA and have the macro in it

If not you can do it with INVOKE CODE activity with VBA as language

Cheers @hsendel