Compare Cell Colors, Return Cell Contents of Second Cell

  • Hello,

    As part of a large food costing and recipe book, I need to pull data from one sheet based upon the color of a cell on the other. On the main data sheet I have multiple tables from various suppliers, on the second sheet I have organized some of the data based upon the type of ingredient, rather than the supplier. I have color coordinated the ingredients based upon supplier, and want to use that color to tell a function which table to look up a price in. I think this should be simple, but I'm over my head..

    More simply put:

    I'm trying to compare a referenced cell to another from a different table based upon its color, then return the value (text) of the second cell. I think this should be simple with VBA, but I'm over my head.


Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!