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

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

OK, I am not getting anywhere...

I have played arond with other approaches, but I just cannot get vba to correctly identify the color code and then run the macro. Attached a sample and in general what I would need.

* the attachment is a survey result with all the data displayed in column B. however, the rating section of the survey is formatted differently, showing me the rating scale of 1 to 10 plus "Not sure" and "Did Not Use" in columns B to N.
* the rated score of the respondent is highlighted in either Red, Yellow, Green or Blue, while all other matrix scores are highlighted in WHITE
* Now what I would like to have is the respondents score copied over to column B. I tried to approach this by telling VBA to look through columns B:N and copy the cell content of any cell that is NOT WHITE, but that seem to work.
* another approach I tried is to loop through columns B:N and search for Red, Yellow, Green or Blue highlighted cells, and if any, copy the cell to column B of the active row. No success.

So, if there is any suggestion from one of the excel masters here, I would greatly appreciate it.

Thanks,
A2k

Survey sample.xlsm