Update row text in green color in excel

[Chaithanya_Rayankula]

Hello Everyone,

I have an excel where i will lookup some data in excel. If it matches with my condition then that row text should write in green color. Set Range color will not work because the whole row is highlighting with green color.

Please let me know if you know the answer. Really appreciate it

Thanks,
Chay

[mahmoud.zaky]

Hi @Chaithanya_Rayankula,
you can find more than one answer in below URL for sovling your issue if you still face issue please update us

Change the font colour

Hi @sruthesanju Please try the below method. Create a text file and past the below vb.net code. Public Function color() Dim rangeToFormat As Excel.Range rangeToFormat = xlWorkSheet.Range(“B1”, “B1”) rangeToFormat.Interior.Color = RGB(255,0,0) End Function Use invoke code activity to execute the above code. Attached screen shot for your reference. [image] Feel free to reach us at any time if you have any doubts. Thanks. Happy Automation

[Anil_G (Anil Gorthi)]

@Chaithanya_Rayankula

You can specify a range or a specific cell to change color in set range color…

So even if you need a specific cell or a ramge of cells both can be passed as inputs

Cheers

[Manish540 (Manish Shettigar)]

@Chaithanya_Rayankula Check this below attached workflow,
Uipath_LookupValue_And_ColorRowText.xaml (6.7 KB)

Files which are used in the workflows:
InputFile.xlsx (8.9 KB)
&
ColorCellText.txt (270 Bytes)

Hope this may help you