Set color to Highlight Entire Rows Based On Condition

[gulshiyaa]

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

[lakshman (Ganta lakshman)]

@gulshiyaa

Good job bro. Yes its really helpful.

[gulshiyaa]

@lakshman

Thank you bro

[kommijeevan (Jeevan Kommi)]

Good Job @gulshiyaa mam

[gulshiyaa]

@kommijeevan

Thank you jeevan garu

[balupad14 (Balamurugan)]

@gulshiyaa,

Very nice …

Regards
Balamurugan.S

[gulshiyaa]

Thank you @balupad14