How to set red colour to complete row text when column "Results" contains failed?

Help Activities
, ,
9

Please install the package BalaReva.Excel.Activities from the Manage Packages interface within UiPath Studio, and use the activity Cell Font.

Regards,
JM

1 Like
10

Only uipath packages recommended.not custom packages .

11

Please see provided screenshot.

image
image716×705 18.6 KB

Regards,

JM

1 Like
12

This gives colour to complete cells, i just want for text.
image

13

image
this complete row is coloured, but i only want text not cells

14

@MitheshBolla

Please see the attached link for an explanation on how to solve this problem with conditional formatting within Excel.

If you’re adamant about solving this issue with UiPath the easiest solution would be to create a VBA script and then running it with UiPath (How to change the font color in the excel cell - #5 by AndersJensen)

Regards

JM

1 Like
15

Hi @MitheshBolla ,

Could you Check the post Below :

Once this is working, we can adopt the method of finding the row indices which are required to be colored.

1 Like
16

hi bro,
I had took this invoke vba code and placed it in my C# project .
i had ran the code , there is no error but still it is not hilighting the Font for paticular cell.

17

Hello @MitheshBolla

You can use the Format cell activity. This can be used to change the Font color or cell color.

2 Likes
18

With this i am able to fill colour in cell.

My requriment is to just hilight font . not cell

19

I think you can modify the font color as well as font style also using this activity.

1 Like
20

We cant change font colour with that activity

21

Yes, you can use that activity to meet your requirement.

1 Like
22

But not font colour.

23

@MitheshBolla Please check the below screenshot. Like this way you can do.

image
image776×448 15 KB

1 Like
24

@MitheshBolla
VBA Solution

  1. copy below code to text file e.g. vba.txt
Function highlightCellRed(columnLetter as string, rowNumber as integer, sheetName as string) 
    Activeworkbook.Sheets(sheetName).activate
    Range(columnLetter & cstr(rowNumber)).Select
    With Selection.Font
        .Color = vbRed
        '.TintAndShade = 0
    End With
    Activeworkbook.Save
End Function
  1. in excel application scope use invoke VBA activity to call the macro
    the entry method parameters are {column letter, row number, sheet Name}
    e.g. {"A",1,"Sheet1"}
    image
    image1180×417 18 KB
1 Like
25

with this can i add font colour to whole row?

1 Like
26

yes but its troublesome, if you want to highlight whole row, do this instead

  1. add below code to vba.txt
Function highlightCellRedWholeRow(rowNumber As Integer, sheetName As String)
    ActiveWorkbook.Sheets(sheetName).Activate
    Rows(CStr(rowNumber) & ":" & CStr(rowNumber)).Select
    With Selection.Font
        .Color = vbRed
    End With
    ActiveWorkbook.Save
End Function
  1. use invoke VBA in excel application scope, set function name = highlightCellRedWholeRow,
    entryMethodParameters = {rowNumber, SheetName}
    e.g. {2, Sheet1} to highlight row 2 in sheet1
    image
    image1239×317 17.3 KB
1 Like
27

image
how to write in c#

28

new object[]{rowCount,eachSheetName}