Delete cells that are highlighted in yellow?

Help Studio
, ,
1

Is it possible to delete numbers in highlighted cells only? I need to delete anything in highlighted cells of a excel worksheet and they are placed at different columns and rows of the worksheet.

2

Try using the Excel get cell colour activity to identify which cells are highlighted?

3

can you show me what you mean?

4

Yeh I can try and help. How many columns do you have?

My approach would have been to use a for each row, loop through each row and get cell colour of column A, then Column B. Use an if statement to say if Column B is “Color [Yellow]” then Write cell as blank…

5

Doing this with our current activities can be very slow if you have a big file, take a look at his instead:

2 Likes
6

I have 5 columns. Column G, H, I,J, and L.

7

With so many columns you might be better to look at bcorrea’s solution. I’ve attached what I would have done. In my solution I have worked this columns G and H. You would need to add in I,J and L.

Does this help? CellColours.xaml (13.8 KB)

8

I can’t open your solution. Can you send it in a zip form?

10

CellColours.zip (2.4 KB)