Hi,

In the range C3:BC277 I have an arrayformula. In each row there will always
be one cell with the value 1 and sometimes a cell with the value 2. 2 will
always be to the right of 1.

The sheet is basically a gantt chart, so I would like to colour the cells
with values 1 or 2 - this is easy enough, but colouring the cells between the
1 and the 2 is giving me some trouble. I cannot use xlToRight since all cells
contains a formula, so what to do?

Any pointers?

/Sune