I have an Excel Sheet where I read the range from H1 - EA1. After that I want to loop throug the Data row to get the yellow cells (get cell color).
The Bot should write a range from another table into the yellow cell. How can I identify the yellow cell to write in? The yellow cells are not always the same and changes.
How do I loop through each cell item in the data row H1, I1, J1… - EA1 and identify the yellow ones?
Or Maybe is there a smarter way to identify specific dynamic cells in Excel?
Thanks a lot.