Conditional formatting - Apply to named ranges
Currently if you apply conditional formatting to a named range (i.e. a range named via the Name Manager or a table style named-range), the value in the "Applies to" column of the Conditional Formatting Rules Manager will immediately revert the named range to its absolute cell reference.
eg. "Applies to: =Table1[Column3]" becomes "Applies to: =$C$2:$C$7".
Apart from being more difficult to read, it creates other complexities. For example, if I insert a new column into this range, it creates a mess in the rules manager, creating a new rule for each cell pasted.
Same for me.
that is exactly what I would like to have!!!