How to add color to Excel cells(A2)

Help Studio
, ,
1

Hi All,

I would like to highlight the some of Excel Cells, As per below screen. Please help me how can i highlight the “A2” Cell in Excel.

Thanks in Advance,
Niranjan

2

i think you missed to add the screen you mentioned. But you can use set range color activity

image
image1152×648 14.5 KB

You could also use excel VBA

1 Like
3

Hi @Niranjan_k

Use can use Invoke VBA activity.

Sub HighlightCell()
    Range("A2").Interior.Color = RGB(255, 255, 0)  'Yellow color
End Sub

You can add if any more cells are needed in the same way.

Paste this code in a notepad file pass this path and method name as HighlightCell.

Hope it helps!!

1 Like
4

@Niranjan_k

Input:

image
image533×762 7.26 KB

Output:
image
image587×774 7.94 KB

Code Text file used:
Input.txt (94 Bytes)

Check out the workflow file for better understanding
Sequence7.xaml (7.1 KB)

Hope it helps!!

1 Like
5

@Niranjan_k

If you find solution for your query please mark it as solution to close the loop.

Happy Automation

Regards

6

@Niranjan_k

If using classic activities use set range color activity

If using modern activities use format cells activity

Cheers

7

Hi @Niranjan_k

You can use modern activity format cells

image
image1047×471 19.1 KB

1 Like
8

@Parvathy I’m in able to open the file can you share me screenshot of workflow

9

Hi @Niranjan_k

image
image856×832 35.5 KB

Regards,

1 Like
10

@Parvathy for Invoke VBA I’m not getting these many options. I got only two options

11

hi @Niranjan_k

Are you using Classic activities. If yes specify.

Regards,

12

@Niranjan_k

If classic activities follow the below workflow:

image
image856×581 16 KB

Text file passed:
Input.txt (94 Bytes)

Regards,

1 Like
13

@Parvathy thank you for quick reply, But here I’m get ting Excel Application Scope: Error opening workbook. If Excel is installed, Run the “repair tool for Microsoft office interop’ from the tools tab on the Home Screen

14

@Niranjan_k

You need to have excel installed to run macro codes.

Regards,

15

@Parvathy Yes i did UiPath.Excel.Activities right, if not please suggest me

16

@Niranjan_k

Don’t you have Microsoft Excel installed in your machine.
Regards,

17

@Parvathy Yes I have. But still I’m same Error

18

Hi @Niranjan_k

Make sure you have Excel Add in installed
Home-> Tools-> UiPath Extensions

image
image1762×1002 63.2 KB

Make sure you have UiPath.Excel.Activties installed
Manage Packages-> All Packages-> Type UiPath.Excel.Activities-> Install-> Save

Regards,

1 Like
19

@Parvathy I have checked it is installed on my machine, another way we can fix this issue

20

Hi @Niranjan_k

Try this:
For this you need the dependancy UiPath.Excel.Activities

image
image511×523 12.9 KB

Click on Fill-> Give the respective color-> Click OK
image

Regards,