How to copy the colour of cell in various row in UiPath.?I hve an Excel fill in which some cells have written=n and it is of red colour.so how to copy the colour in various rows.
Tia
Hello @Cuberoot, try this:
Excel Application Scope (Specify Excel file path)
Read Range (Output to DataTable)
For Each Row (In DataTable)
If (Row(“YourColumnName”).ToString = “=n”)
Get Cell Color (Specify cell address based on the current row)
Assign (Store the color value in a variable)
End If
Continue with your automation process
Make sure to replace “YourColumnName” with the actual column name where “=n” is expected, and adjust the cell address calculation based on your Excel sheet’s structure. This way, you can copy the color of cells in various rows when the cell value matches “=n.”
Hope it helps, cheers! 
