Set color to Highlight Entire Rows Based On Condition

Hi Everyone,
I hope this would help everyone those who are trying to set color based on condition which highlight entire rows

[ In this case My condition was If Bit Rate 0.0 kbps Color the entire row ]

Steps…

Step 1: Use excel application scope and select the path then read the sheet

Step 2: pass the variable in For each row

Step 3: Use assign activity var count = count + 1

Step 4: For condition use if condition activity and write your condition [ In my case Row(“Bit Rate”).Tostring = “0.0 kbps” ] and if the condition is true Then

Step 5: Use set color activity inside the then part and in property panel Input
Color – System.Drawing.color.red(which color you want)
Range – “A”+(count+1).ToString+":B"+(count+1).ToString -----[according to my case]
change the cell according to your sheet.
Sheet Name – “Sheet1”

------ By this you can Highlight your entire row Based on your condition

cool,
Regards,
Gulshiyaa,

Thank you

6 Likes

@gulshiyaa

Good job bro. Yes its really helpful.

@lakshman

Thank you bro

1 Like

Good Job @gulshiyaa mam :clap::clap::clap:

1 Like

@kommijeevan

Thank you jeevan garu

@gulshiyaa,

Very nice … :clap::clap::clap::clap::clap:

Regards
Balamurugan.S

Thank you @balupad14

1 Like