Hello,

I like to get a module which gives me the number of background red colored cells within each row (a loop)

Row 2 till last
The number of red colored cells in this row to report in column B.
The range to look at is in active row column C till F and in the same row also in column K till S.

If in the first range 1 cell is colored red and in the other range 3 cells, then in this row column B should be reported 1+3 - 4.

If somebody can help me out.

THANKS.

regards, Johan