Please tell me how to paint the cells in green, provided that the word “update” appears.
At the moment, the program adds excel files from the directory to the database and looks for the word “update”. How to implement the selection in green, provided that we do not know in advance the range in which it is necessary to paint over.
Thanks. But the word “update” is not the only one in the cell, for example “02.12.2005 update”. Can you use for each row to look for exactly the word update? As I understand it, regular expression only searches in text and not in database rows.
@sereganator - I have developed a workflow in UI Automation which does this job for you.
please let me know, if you are interested in that.
The reason why I choose this route, in order to use “Set Range Color” activity we need to provide the range, which a cell value of A2 or B2 or A1:B2 like this…which is really difficult in your case because we have to extract the cell address where the word “Update” found…