How far is the first occurrence of a coloured cell

[RIC63]

Hi to everyone
I would like for each row in column A, to be returned the number of cells present starting from column C that do not have set the background color until the first occurrence of a cell with a green background color, see the attached sample.

thanks for any help

[p45cal]

See formula in column AJ.

[RIC63]

Good morning p45cal


that's exactly what I meant


sincere thanks