B
Blue Max
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?
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?