Reading the values of random Excel cells by color and paste in a new sheet

Hi Everyone,
I am seeking your help to understand the scenario,
"how to fetch values of random cells by its color and paste the result in new sheet one by one" using Blue prism.
Example: In new sheet, column A should have all the values of a colur yellow and column B should have values of color Red.

Please refer the attached excel with actual and expected output.
 

Attachments

  • Excel Scenario.png
    60.7 KB · Views: 43

SaJ

New Member
hi

You can use excel interior color property to fetch the cells based on colors.

for ex:
If (excel.Range (Cellreference). Interior.Color = "255") = True
x=Cellreference.Value

here 255 is RGB value for Red
 
Top