Holding down shift key

[Steven_Kho]

Hi Experts,

I have been receiving alot of help from the Experts in the community and I appreciate everyone’s help! I am still a beginner in using UiPath studio.

For this question, I would like to ask, how can I hold down the shift key.

Firstly, I want to hold down the shift key and press the ‘down’ hotkey to highlight the cell range. However, the number of times I press the ‘down’ key is determined by the number of descriptions I have using ‘While’ activity (Loop).

Below is the script I built.

[gulshiyaa]

Hi @Steven_Kho

In sendhotkey please Indicate the screen

If this’s your solution please mark as solution
Regards,
Gulshiyaa

[Steven_Kho]

Hi @gulshiyaa

That’s not the solution, sorry.

[MuralidharVankamaddi (vmdr56)]

@Steven_Kho,

User select range activity and specify the range(like “A1:A6”}

[Steven_Kho]

Hi @MuralidharVankamaddi

The range will differ based on the ‘Description’ variable.
So I cannot pre-define it

[gulshiyaa]

do you want to highlight the cell based on condition?

[Steven_Kho]

Hi ,Yes

[mukeshkala]

hi @Steven_Kho,

I am not sure wether this will work -

you can put only the Shift hotkey before the while loop.
Inside the While Loop - we put only Down key.

–
Mukesh

[gulshiyaa]

Plz Check With this

Set color to Highlight Entire Rows Based On Condition

Thank you @balupad14

If you want to change color you can change

[Steven_Kho]

Hi @mukeshkala

Sorry that does not work

Thank you

[mukeshkala]

Is this how the data is Placed in Excel and you want the select . Here I am having till row 13 only. …

If possible can you show how data is placed in excel .

–
Mukesh

[Steven_Kho]

My aim is to highlight these “Social Media Campaign…”.

[mukeshkala]

Okay - Is the text at the Beginning Consistent - Social Media ?

[Steven_Kho]

Hi, yes.

Currently I am trying the method recommended by @gulshiyaa

1. Assign activity: ‘Range’ -> “A19:” + “A” +(Description+18).ToString
2. Select Range activity: ‘Range’

this solution managed to work