Novigo Solutions is an end-to-end IT Solutions provider, specialized in full cycle IT Services and platform solutions

e6653b86-6191-494c-b705-57f8d49ea57c.png

a2a8aa67-aa9e-4fee-8461-b805cf343b31.jpeg

RPA Developer

7e99a8c8-8551-4d28-a3c0-f605420d8094.zip

This Snippet has four arguments:

  

**1\. in\_FilePath (String):** Path of the Excel file for reading and colouring the cells with special characters. **Required.**

**2\. in\_SheetName (String):** Name of the sheet in Excel file. **Required.**

**3\. in\_ColumnName (String):** Name of te column to check for special characters. **Required.**

**4\. in\_ValidSpclCharArray (String \[\]):** Array of String containing special characters which are acceptable. **Optional.**

Reads Input file and colors all the cells which contain any of the special characters except for those which are mentioned in the Array of String

Version	Release Date	Download Link
1.0.0	September 1, 2020
Initial release

Color Cells with Invalid Special Characters