Write data from one column to the one next by.

Hello folks,

greetings from Germany.

I've got an if-statement that match the background color of a cell. Works fine, but it's not made by me. So, I'm far away to understand the details.

What I want to achieve is that if a cell is blue, the neighboring cell has a 1. Because the script only asks for a certain blue color, the 1 in the neighboring cell should represent a visual check.

I'm pretty shure it's an easy task for the professionals.

The trouble in the script starts at line 51.

Please Login or Register  to view this content.

bgColors[i][k] looks to me as a cell coordinate. I mean, is one. But to manipulate this, I failed.

Link:
docs.google.com/spreadsheets/d/1j4sOusYeuqHgMWqTNbwf1Y-4YIIBPT1dm2KyY8HAImw/edit?usp=sharing

I have to apologize for my buggy English. Please take a look to the sheet, it's very easy to understand.

cheers,

sinnie

Hi janmorris,

sorry, to eliminate the two slashes in line 51 shows only an error.

I've just made the code to editing, sorry for don't do it in first place.