Script to change font colour

[sruthesanju (Sweety)]

How to change the font colour in Ash for particular cell using script

[ppr (Peter Preuss)]

have a look on the balareva package:

[sruthesanju (Sweety)]

I should not use this package for my prjoct

[athira.somasekharan]

Hello,

Have you tried using Set Range Color activity?

Set Range Color

Thanks!
Athira

[sruthesanju (Sweety)]

Yes tried,but it’s not working correctly .i need script for this code

[sruthesanju (Sweety)]

It’s changing the background i need to change the text colour

[sruthesanju (Sweety)]

Any updates

[supermanPunch (Arpan)]

Hi @sruthesanju ,

Could you Check the below Discussion. There is a Solution available which you can try :

How to change the font color in the excel cell

@Vrushali_Gave The first Excel file that you had provided were not having the same template in all 3 sheets But this new file has the same template in all 3 sheets. Maybe I have got the output that you required. Can you just check the Output Excel below and verify if that’s the output that you require ? Book1.xlsx (14.8 KB) If it is not the required output, Can you provide us the Expected Output, then we can be more clear as to what we need to do.

[Rahul_Unnikrishnan]

Hello @sruthesanju ,

Please see the below video. Format cell activity.

UiPath - Set Cell Color, Alignment, Font Style | Format Cell Activity |UiPath Tutorial

[sruthesanju (Sweety)]

I need to change the value colour not cell colour

[Rahul_Unnikrishnan]

Inside the Format Cell activity you can click on set format. There you can select the Font and the color which is required.

Format cell activity can be used to change DataType,Alignment,Font and to fill color.

[kumar.varun2 (Varun Kumar)]

Hi @sruthesanju

This implementation is through macros script. Please check

RangeColour.zip (11.7 KB)