Hello Charles,

Thank you for the reply. Given your answer, however, it appears that I may
have communicated our question poorly. I was referring to a range specified
in the 'Applies To' field of the 'Conditional Formatting Rules Manager'
dialog versus the actual formula for the Conditional Format. This field
designates which cells the conditional formatting rule currently apples to.
It is in the 'Applies To' field where we seem to have the problem of Excel
converting the named ranges to simple range references; thereby losing the
dynamic features of the named range. Does this help clarify the issue?

Thanks,
Richard

****************
"Charles Williams" wrote in message
...
Works fine for me: I created a dynamic name range called Fred, inserted a
conditional format formula =SUM(Fred)200
and when I extended the range so that the sume became greater than 200 the
conditional format was triggered.

Charles
___________________________________
London Excel Users Conference April 1-2
The Excel Calculation Site
http://www.decisionmodels.com

"Blue Max" wrote in message
...
We have created a series of named ranges which were defined using the
OFFSET() function. The purpose of this was to define ranges that would
always properly adjust when new rows or columns were inserted into the
table with the cursor position on the top row or left column of the table
(these positions normally add rows or columns outside the specified
range - i.e., range does not adjust in all formulas).

This works well, until we try to use defined names with the 'Conditional
Formatting' feature. If we use a named range to specify the range for a
conditional formatting rule, the named range is converted to the actual
resulting range. The problem here is that the range used for the
conditional formatting is no longer dynamic. It is a fixed range that no
longer matches the named range if it is changed in the ways described
above.

We suspect that this treatment may also be evident elsewhere in the
program. Does anyone know why conditional formatting rules do not retain
the range as the defined 'Range Name' originally specified by the user?
Likewise, does anyone know how to force the rule to retain the name
versus the range, so that it will dynamically change when needed?