Fill excel color / highlight cells

Help
1

Hi All ,

I am trying to see if a cell in the excel sheet can be highlighted/filled with a color based on a condition, Is this doable using UiPath.

Thanks

1 Like
2

Check this

Color Excel

5 Likes
3

Hi @vvaidya

I am getting a weird error when trying the set range.

4

Whats your range value in Set Color?

5

Realized the excel sheet was protected,

6

Hello - I came across this and begin testing in my environment. In my excel sheet, I’m trying to highlight rows where the previously calculated variance is >0. In you example your have “length” as the criteria. How can I change that to accommodate my scenario? Please let me know if I need to explain myself further. Any help would be appreciated. Thank you!

7

Something like this?

dtTable1.Select(“Variance > 0”)

8

Thank you for the prompt reply. I’m getting this warning:

Compiler error(s) encountered processing expression 'dtTable1.Select(“Variance >0”).
Value of type ‘1-dimensional array of system.Data.DataRow’ Cannot be converted to Boolean.

Any advice on what this may be? Thanks!

9

Should have been more specific Variance is the column where you are calculating variance and it should be assigned to Data Row Array.

10

Makes sense, thank you. One more question. I’m getting this error. I assume its because “Variance” column is repeated 3 or 4 times in the excel sheet. Could that be the issue?

Here is the whole workflow:

image.png554×659 29.6 KB

11

Yes column name has to be unique.

12

Thanks again!!!