Is it possible to change the color/font of string of data row variable

Help
1

Hi All,

I’m fetching the data from excel and storing all the data in datatable variable named as products_dt. Based on certain conditions of particular columns I have to change color/font of string.

For e.g Compare Column Value1 and Value2
In case of equal : Color should be green in column named check which would be part of the datatable.

Problem statement : Here, I’m looping through the datatable and I’m able to assign the value by comparing the columns. However, not able to change the color or the font. Any insights how it can be done?

Thanks and regards,
Ilangos

1 Like
2

@Ilangos

You can use set range color activity

For your reference check this Fill excel color / highlight cells
dtArray.zip (8.2 KB)

Hope this helps

Thanks
Aman

1 Like
3

Hi aman_sheik,

Thanks a lot :slight_smile: It helped.

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.