Created attachment 79229 [details]
Screenshot of the conditional formatting dialog not accepting a named range reference,

Problem description: 

When working with conditional formatting, the rules are automatically adjusted when, for example, additional cells are inserted in an affected range. The user ends up with several rules for copied cells or altered rules for ranges which don't include the newly inserted cells.

It would be great if the user were able to use named ranges for conditional formatting. These rules would not have to be automatically adjusted for changed cell ranges, but just always refer to the same named range.

However, in the editing dialog for conditional formatting rules, the input entry for "Range" only accepts cell references, not references to named ranges. If entering the name of a named range, its background turns red and the formatting rule is not accepted.

Steps to reproduce:
1. Select some cells in an empty Calc document (e.g. A1:B9)
2. Create a named range by entering 'testrange' into the Name Box.
3. Choose Format - Conditional Formatting - Condition
4. The "Range:" field displays the selected cell range as A1:B9
5. Enter the defined name "testrange" into the field.

Current behavior:
The background of the "Range:" field turns red and the conditional formatting rule cannot be created.


Expected behavior:
The conditional formatting rule is created for the named range and affects all cells that are part of the named range. Subsequent changes to the named range definition do not alter the conditional formatting rule, which constantly refers to the range name.
              
Operating System: Windows 7
Version: 4.0.2.2 release