How to appy red font color data to excel data in uipath

Help Studio
1

Hi I want to apply red color to data in excel in a column ,here i dont want to apply color on the column i want to apply only on the data

2

@T_Y_Raju
Can you share the input and expected output

3

@T_Y_Raju,

Use Format Cell activity.

Thanks,
Ashok :slight_smile:

4

Filter Rows.xlsx (10.4 KB)
sheet 3 in input data
sheet 1 is out put data

5

Hi @T_Y_Raju

You can use the Format cells activity to apply the color to the specified range data in excel.
Click on set format option → Click on Fill tab → Select the color from the dropdown → Click okay

Check the below image for better understanding,
image

Hope it helps!!

6

Hi @T_Y_Raju

image
image951×707 36.1 KB

Output

image
image351×758 8.55 KB

Hope it helps!!

7

@T_Y_Raju

Sub ApplyRedColorToColumnData()
    Dim ws As Worksheet
    Dim rng As Range
    Dim cell As Range
    Dim columnNumber As Integer

    ' Set the worksheet you want to work with
    Set ws = ThisWorkbook.Sheets("Sheet1")

    ' Set the column number you want to apply the color to
    columnNumber = 1 ' Example: Column A

    ' Get the range of the column excluding the header
    Set rng = ws.Range(ws.Cells(2, columnNumber), ws.Cells(ws.Rows.Count, columnNumber).End(xlUp))

    ' Apply red color to each cell in the range
    For Each cell In rng
        If cell.Value <> "" Then
            cell.Interior.Color = RGB(255, 0, 0)
        End If
    Next cell
End Sub

Try this vb code in Invoke Vba activity hope it works for

8

image
image800×373 49.7 KB

9

@T_Y_Raju

Have you tried my solution

10

not yet iam tryinh with format cell option but iam getting error

11

@T_Y_Raju
Try If you get any errors let me know

12

Format cells is the modern excel activity you have to use inside the use excel file activity.

→ Use the Excel process scope activity → Insert use excel file activity and provide the path of the file → Inside use excel file activity insert the Format cells activity.

Then it will work, give the range like below,

Excel.sheet("Sheet name").Range("Z"+CellNo.tostring+":Z"+Lastrow.tostring)

Hope it helps!!

13

ok let me try and check thank you

14

here i see that column is getting colored in blue ,…i want only the data to be get colored with blue

15

will this macro will paint column or data in color

16

@T_Y_Raju

Have you checked with format cells activity.

17

@T_Y_Raju

it will colour the data only.

 columnNumber = 1 ' Example: Column A ----->in this give your column Number
And pass your sheet name
18

It’s always good to search the forums before posting. There are tons of posts on this already.

19

i see that cells are getting coloured not the data can you please check once

20

@T_Y_Raju

Sorry for that please check this vb code it will work for you

Sub ApplyRedColorToColumnData()
    Dim ws As Worksheet
    Dim rng As Range
    Dim cell As Range
    Dim columnNumber As Integer

    ' Set the worksheet you want to work with
    Set ws = ThisWorkbook.Sheets("Sheet1")

    ' Set the column number you want to apply the color to
    columnNumber = 1 ' Example: Column A

    ' Get the range of the column excluding the header
    Set rng = ws.Range(ws.Cells(2, columnNumber), ws.Cells(ws.Rows.Count, columnNumber).End(xlUp))

    ' Apply red color to the text in each cell in the range
    For Each cell In rng
        If cell.Value <> "" Then
            cell.Font.Color = RGB(255, 0, 0)
        End If
    Next cell
End Sub

Output:

image
image709×149 5.07 KB