Color Cells dynamically wherever "FTP ERROR" is encounterd

Hi,

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

Thanks in advance :slight_smile:

1 Like

Hi @Neha2111

Please use Set Range Color activity. Documentation below:
https://activities.uipath.com/docs/excel-set-range-color

Thanks and regards.

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

1 Like
  • 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.

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

Hey buddy…

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

Regards,
Neha

1 Like

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