Hoiw to set the color in excel cell?

Help
, ,
1

Hi,
color1
I need to set the color in updated status column, If the updated status is success means I need to set
green color in that cell and if it is in fail status means i need to give red color.
As per my script, success and fail will change in that updated status column.
Can anyone guide me how to do this ?

1 Like
2

@jamunatj

You can use the Set Range Color activity within the Excel Application Scope for this purpose.

2 Likes
3

Okay, how I need to give success status is green color and fail status is red color.

4

HI,

Maybe you could create the excel file from a template that has been saved somewhere and do the conditional formatting on that template. When you populate that excel sheet the formatting you want will be there.

3 Likes
5

There are different logics you can use.

One is using a for each row and checking if the status is “success” Then Set Range Color to green, else Set Range Color to Red.

The other way will be to do a DataTable.Select([Uploaded Status] = “fail”) and then apply the Set Range Color to Red on the resultant output and similarly for Success.

1 Like
6

That’s a very useful tip. Thanks!

1 Like
7

no probs

8

Hi @jamunatj ,

Here is the document for the set color range.

Regards
Balamurugan.S

2 Likes
9

Hi Jamuna Ji,

I hope this demo helps:

1 Like
10

Hi @SowmyaLeo

That is not working Can you please elaborate

Thanks