Forum Discussion
Need help to extract data in a certain way based on cell color
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.
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.
