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

%3CLINGO-SUB%20id%3D%22lingo-sub-414799%22%20slang%3D%22en-US%22%3ENeed%20help%20to%20extract%20data%20in%20a%20certain%20way%20based%20on%20cell%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-414799%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20guys%2C%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EFirst%20of%20all%20i%20would%20like%20to%20apologize%20for%20the%20newbie%20question%20here.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3ESo%2C%20i'm%20trying%20to%20figure%20out%20how%20can%20i%20extract%20certain%20data%20in%20a%20certain%20way%20on%20a%20different%20Cell.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3EI%20was%20thinking%20of%20explaining%20it%20but%20the%20image%20will%20do%20that%20better%20i%20assume.%26nbsp%3B%3CBR%20%2F%3EIn%20case%20i'm%20missing%20something%20please%20let%20me%20know%20so%20i%20can%20further%20explain.%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F106326iB23D4B3F7CD8FBD3%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22123123123.png%22%20title%3D%22123123123.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThank%20you%20in%20advance.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-414799%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-419108%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20to%20extract%20data%20in%20a%20certain%20way%20based%20on%20cell%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-419108%22%20slang%3D%22en-US%22%3EExcel%20cannot%20calculate%20based%20on%20cell%20color%2C%20unless%20you%20use%20VBA%2C%20which%20I%20find%20to%20be%20overkill.%20A%20better%20way%20would%20be%20to%20rethink%20your%20data%20setup%20and%20use%20information%20entered%20in%20cells%20to%20indicate%20which%20cells%20need%20to%20be%20included%20and%20which%20not.%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

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
Highlighted
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.