Colour cell in the execel

Hi Team ,
I have one excel I want to changes the colour of text which have type changed
Typenew.xlsx (11.3 KB)
Please refer excel
sheet 1 is input and sheet 2 is output

Hello @Kuldeep_Pandey

I found this particular activity in Balareva Easy Excel package. First I tried with the latest version, but it seems this “Cell Font” activity is discontinued. But luckily you can get it in it’s older versions (I found it in version 8)

For this, first you need to find which row has the Type as Changed and then put the corresponding cell/cell range into the properties of the activity.

Follow along other requirements (Sheet Name, Font Color etc.), voila, the problem solved.
Feel free to ask for details.

Cheers

How to found cell no?if changed type

Hi @Kuldeep_Pandey ,

Could you maybe also try with the combination of Excel Modern activities - Excel Process Scope, Use Excel File, For Each Excel Row and Format Cells activity.
image

Hi @Kuldeep_Pandey

Here is the file as @supermanPunch had shown in the picture.

Excel_TextColor.xaml (11.6 KB)

and look at the configuration inside Format Cells activity.

Hope we could help.

Hello @Kuldeep_Pandey

Please check the below video. You can use Format cell activity to acheive this.

Thanks