i'm wondering if this can be done with vba in excel 2007. i've two columns in my sheet1. in column A i've few cells(say about 10 or so) that are colored red and then green (again a few cells) and blue and so on. For every red colored cells from column A, there's a cell in column B, that matches the color with them, for every blue colored cells in column A, there's again a blue colored cell in column B.
what i want is to get a code, that matches all the cells of same color from Column A with the same colored cell of column B and copy that cell from column B to sheet2 Column B respective to the same colored cell from Column A of sheet2.
i hope i didn't messed up.