Bulk editing formulas with slightly different content

[mtaylor]

Hi all,

Thanks for looking.

I'm using Google Sheets - but guessing this would be the same for Excel.

I have numerous cells with a formula setup like this:

=countif(KG2A!$C$5:$C$19,"Green")

Across the cells the 'KG2A' would change and the colour at the end would change.
The numbers after the $ in the centre of the formula would also change.

Is there a quick method of editing all the cells' formula so the cell reference part is simply: $C:$C

Essentially the example above should read:

=countif(KG2A!C$:$C,"Green")

Many thanks