Conditional formatting with 3 color scale. Copy format to other cells

JuttaWERU 

Sorry didn't notice that you use a color scale.

You cannot use relative references in conditional formatted criteria for color scales, data bars, or icon sets.

You can change "Applies to" with R1C1 but no references in the reference cells.

This is only possible if you don't use color scales, data bars or icon sets in conditional formatting.

For your project, I can blindly agree with Mr. Sergei Baklan’s  proposed solution :))

Attached are Mr. Sergei Baklan’s formulas, translated into German.

Add these as instructed by Mr. Baklan.

Minimum

 =BEREICH.VERSCHIEBEN($C$2; ZEILE()-ZEILE($A$1)-1; 0)

Mittelpunkt

=(BEREICH.VERSCHIEBEN($B$2; ZEILE()-ZEILE($A$1)-1; 0)+BEREICH.VERSCHIEBEN($C$2; ZEILE()-ZEILE($A$1)-1; 0))/2

Maximum

=BEREICH.VERSCHIEBEN($B$2; ZEILE()-ZEILE($A$1)-1; 0)

Thank you for your understanding and patience