Color Cells dynamically wherever "FTP ERROR" is encounterd

Help
1

Hi,

Is there any way I can color my cells “Red” wherever bot encounters “FTP ERROR” in any column of the excel sheet.

Capture_color
Capture_color1245×557 12.4 KB

Thanks in advance :slight_smile:

1 Like
2

Hi @Neha2111

Please use Set Range Color activity. Documentation below:

Thanks and regards.

3

Hi,
I just don’t want to color a particular cell. I want it in random places wherever there is “FTP ERROR”.

1 Like
4

  • Load everything in to an datatable.

  • Iterate trough this table with a for each loop.

  • Iterate trough each item and check if the item.contains(“FTP ERROR”)

  • Then use the Add color activity from excel when you write it back. Cause you know the location now.

5

Hi @Neha2111

Its resolved buddy, (thats a good question buddy)
here you go, runt the xaml and open the excel file once after job gets completed
cellcolor.zip (9.5 KB)

Hope this would help you
Kindly try this and let know buddy
Cheers

1 Like
6

Hey buddy…

Thanks a lot :slight_smile: Its working. :slight_smile:

Regards,
Neha

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.