Edit Excel Spreadsheet Based on Condition Outside of Excel


#1

Hello,

I am using read range/for each/get row item activities to read numbers in a column and enter each number individually into a SAP transaction. If a specific element exists in SAP I may need to highlight the specific cell in Excel that contains the number I just entered before moving onto the next number in the column. I am attempting to use a “set range color” activity. I cannot get it to work. I know the robot is recognizing the element successfully because there is another activity before the “set range color” that is predicated on the same element existing and it performs this activity successfully. The robot skips over the “set range color” activity and moves onto the next number to be entered in the column.

Any assistance would be greatly appreciated.