Conditional Format "Applies To" When Adding Rows or Columns

My spreadsheet includes conditional formats unique to each column (ex: Applies to $E$3:$E$50). If I add a row (ex: using insert or copy/insert copied line and row 27 is now inserted), the column format is not included. If I go to another cell in the same column, the 'Applies to' is now automatically set to $E$3:$E$26, $E$28:$E$50). Is there a way to keep the conditional format if I add a row within the column format range which does not require manual manipulation of the conditional format for the new row?

Special-K,

I created a cell with the conditional format (formula is used to apply format) and provided a name in the NameBox (ex: WEEK1). How do I apply this NameBox to other cells for conditional formatting? Reference a formula using WEEK1? In the example you referred me to, I don't know where to apply 'Total' in the conditional format for other cells (in the formula area or applies to area?).

Thanks.