I have set of numbers in a range , say B2:F6, that are colored differently due to conditional-formatting. I'm looking for a sub to find/identify say YELLOW cells in range B2:F6, then copy YELLOW cell values, then paste the values into YELLOW col. starting in cell B10, and do same for other three colors. The SUB needs to go through all colored cells in range B2:F6 and identify cell values corresponding to different colors (in this example only 4 colors are used) & paste corresponding values into cols. B to E, row 10 downwards. I would have liked to attach a worked example (.xls), with expected outcome, but do not know how to, on this forum.