I have set a conditional formatting for Cell B10

=OR(C10D10*$G$1,F10G10*$G$1)

$G$1 is the absolute referece and the other cells are relative reference.

This means the formula for condtional formatting of Cell B11

=OR(C11D11*$G$1,F11G11*$G$1)


Is there a way to copy the conditonal formatting up to Cell B2000


Thanks.

Igbert