UNSOLVED - Identify highlighted cells in column, copy cell value to column B of active row

[Armitage2k]

Hi,

I have selected columns B to O on my worksheet and now need a way to loop through the cells and see if:

1. selected cells are have a color highlight (can be green, yellow or red)
2. copy the cell value of the highlighted cell to column B of the respective row

Any suggestions on how I can manage to do this via VBA?

Thanks,
A2k