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