Excel Automation: Highlighting entries that contain a certain percentage

[h2000]

Hello!

I have a table full of entries in excel that contain percentage values (Eg: 1%,2%,7%,0%…).

I want to highlight all cells that don’t contain 0% or 1% in the excel table. How is that possible using Uipath?

Any help would be much appreciated! Thank you!

[NIVED_NAMBIAR (NIVED N)]

Hi @h2000

Try above by putting a condition and then use color cell activitiy to color the particular cell so that it can be high lighlighted

[h2000]

Thank you @NIVED_NAMBIAR for your reply! I was hoping to use an ‘If’ Statement but am unsure of what to put inside! If you would be kind enough to guide me on that, that would be awesome! (I am new to Uipath )

Thanks so much!

[NIVED_NAMBIAR (NIVED N)]

Hi @h2000

Can u share the sample excel file ?

[h2000]

Hi!

Sorry! As I mentioned, I am not able to upload a file here as I am new here, but this is what my data looks like in excel! Hopefully, it is helpful! Thanks so much!

(I need to highlight all cells that contain 0% or 1%)

Percentages
0%
0%
1%
2%
3%
4%
5%
6%
0%
0%
0%
1%
1%
1%
1%
1%
4%
5%
6%
7%
8%
9%
9%
1%
2%

[NIVED_NAMBIAR (NIVED N)]

Hi @h2000

I tried ur query and got the result like u required

Attaching the workflow for reference,
Main.xaml (10.2 KB)

Hope it helps you
Mark it as solution if you got answer to ur query

Regards

Nived N

Happy Automation

[h2000]

Yes, it works! Thank you so much!

Best Regards!