Forum Discussion
JC Reardon
Dec 15, 2022Brass Contributor
Conditional formatting applied to a named range reverts to an absolute reference?
Conditional Formatting Rules can be applied to ranges referenced by Name, but as soon as the rule is applied, that Name is replaced with an absolute reference to the range. When any changes are made...
PeterBartholomew1
Dec 15, 2022Silver Contributor
Sorry but CF is an antiquated pile of junk that Microsoft hesitates to touch*. It is full of weird visual effects that will make your workbook look like a Romany caravan at sunset, but short on practical considerations, such as how to define the 'Applies to' range so that it follows an named range, much less a spilt range. CF has always performed calculations using the array calc. but then it doesn't use it, instead truncating the condition to the top-left value.
Something CF truly excels at is the creation of fragmented and erroneous ranges.
* I do seem to vaguely remember some improvement being made recently. If someone can point me to it that would be useful. I would be delighted to recant some of my criticism.
- MattF1000Feb 14, 2024Copper ContributorHi Peter did you ever find any new info? I'm still experiencing the issue described by the OP.