How to change text color in excel

[Raja.G (Mr.RPABot)]

Hi Team,

I want update text color based on condition should change color to black and red.

Not all the places expected place only i want red font

Please help me any one for this

Expected output:

Regards,
Raja G

[fernando_zuluaga]

Hi @Raja.G

what about the format cell activity?

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

Regards

[Raja.G (Mr.RPABot)]

Hi @fernando_zuluaga ,

I dont want static place i want expected place only i need to change text to red color

[fernando_zuluaga]

Create your own login to get the dynamic value you want, format cell activity will be useful to change the text color

[Manish540 (Manish Shettigar)]

Hi @Raja.G ,

So you have to change the text color where ever the ‘Output’ text is found in a cell and this will be in dynamic right?

[Raja.G (Mr.RPABot)]

Hi @Manish540 ,

Yes correct, i find the ‘output’ text once present i should apply text color red

[Anil_G (Anil Gorthi)]

@Raja.G

Use find /Replace activity…and find output value…it will give you the cell number containing output…

Now use the cell number inside the format cell activity and select the color as red

Cheers

[Raja.G (Mr.RPABot)]

Hi @supermanPunch please help me for this

[Anil_G (Anil Gorthi)]

@Raja.G

Did you happen to try the above method? facing any issues?

cheers

[Raja.G (Mr.RPABot)]

Yes i tried ,That activity not available (Find/Replace)

[Anil_G (Anil Gorthi)]

@Raja.G

Are you not using modern activities?

if so can you click on filter icon and select modern

cheers

[Raja.G (Mr.RPABot)]

Yes came thanks , i ill check and let u know

[Raja.G (Mr.RPABot)]

Hi @Anil_G

What range i should give?

Any Expression require ah?

[Anil_G (Anil Gorthi)]

@Raja.G

In the first one give Excel.Sheet("Sheet1")

and in the second use the output of find /Replace

cheers

[Raja.G (Mr.RPABot)]

@Anil_G

I attached xaml i tried not worked please check and give correct solution
Forum_CellColour.zip (48.9 KB)

[Anil_G (Anil Gorthi)]

@Raja.G

Check this

check the format.xaml
PepProcess - Copy (4).zip (54.2 KB)

cheers

[Raja.G (Mr.RPABot)]

Hi @Anil_G ,

Yes worked but I want only text color not cell color , text only should change red

[Anil_G (Anil Gorthi)]

@Raja.G

In the format cell…click on set format and select whatever properties you need…there you have multiple options…select as you need …both for cell color and font color and other options as well

Cheers

[Raja.G (Mr.RPABot)]

Hi @Anil_G ,

Working fine Thanks