View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Danny Danny is offline
external usenet poster
 
Posts: 148
Default Condtional Formatting - Inserting Rows

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.