My conditional formatting applies to cells (see row numbers):

=$B$41
=$B$42


When I insert 10 rows between row 41 and 42, the condition now applies to
cells as follows:

=$B$41:$B$51

1. Is there a way that the condtions will not be copied to rows 42 to 51?
Or, the condition will apply only to each cell, i.e."


=$B$41
=$B$42
=$B$43
etc. to =$B$51

Thank you.

Use the absolute column reference of $B and the relative row reference of
41 to get the seconf optiont.

=$B41

To not have the CF copied to the inserted rows, turn off the option to
"extend data range formats and formulas"


Gord Dibben MS Excel MVP


On Wed, 23 Dec 2009 11:16:03 -0800, Danny
wrote:

My conditional formatting applies to cells (see row numbers):

=$B$41
=$B$42


When I insert 10 rows between row 41 and 42, the condition now applies to
cells as follows:

=$B$41:$B$51

1. Is there a way that the condtions will not be copied to rows 42 to 51?
Or, the condition will apply only to each cell, i.e."


=$B$41
=$B$42
=$B$43
etc. to =$B$51

Thank you.