Condtional Formatting - Inserting Rows

[Danny]

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.

 

[Gord Dibben]

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