Fill excel color / highlight cells

excel

#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


How to change Excel cell font color
Deleting rows from a sheet after filtering
#2

Check this

Color Excel


How to set color in excel
How to change excel cell color while do the iteration
#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:


#11

Yes column name has to be unique.


#12

Thanks again!!!