I need to automate a robot to check in row Language and if cell color is yellow write color value like in example file “German” in another excel file row and write corresponding country in another row. So it will be If color is yellow write “German” in another excel file row and write “Germany” in another excel file row
Excel1 is sample file
Excel2 is sample file where data should be written.
If anybody have suggestion how I can approach this will be great.