Need help to extract data in a certain way based on cell color

Copper Contributor

Hey guys, 

First of all i would like to apologize for the newbie question here. 

So, i'm trying to figure out how can i extract certain data in a certain way on a different Cell. 

I was thinking of explaining it but the image will do that better i assume. 
In case i'm missing something please let me know so i can further explain. 

123123123.png

 


Thank you in advance. 

1 Reply
Excel cannot calculate based on cell color, unless you use VBA, which I find to be overkill. A better way would be to rethink your data setup and use information entered in cells to indicate which cells need to be included and which not.