Hi Experts! I am trying to formulate the best way to create conditional formatting rules to be able to highlight the whole row based on the words found in column G.
Basically, column G contains all the status of the processing of the macro. It is consist of a sentence or two. I want the rule to highlight the whole row when it detects either one of the words/phrases within the sentence like "with warnings" or "With warning" or "with errors" or "with error" or "was terminated". I was able to formulate using format only cells that contains the following words, however, it is not working whenever i am putting the whole sentence. It only works whenever i only put "with warnings" in the cell. Hope you can help. Thanks!
Sample status below:
JOB_ AVCDDE_123456 Script completed with warnings or remainders. There was 1 warning message. There were no remainder messages. Script ran for 52 minutes and 31 seconds. (Elapsed: 3151 Interactive: 0 Processing: 3151)
Basically, column G contains all the status of the processing of the macro. It is consist of a sentence or two. I want the rule to highlight the whole row when it detects either one of the words/phrases within the sentence like "with warnings" or "With warning" or "with errors" or "with error" or "was terminated". I was able to formulate using format only cells that contains the following words, however, it is not working whenever i am putting the whole sentence. It only works whenever i only put "with warnings" in the cell. Hope you can help. Thanks!
Sample status below:
JOB_ AVCDDE_123456 Script completed with warnings or remainders. There was 1 warning message. There were no remainder messages. Script ran for 52 minutes and 31 seconds. (Elapsed: 3151 Interactive: 0 Processing: 3151)
