Named range in Conditional Formatting

User avatar
ErikJan
5StarLounger
Posts: 1185
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

Named range in Conditional Formatting

Post by ErikJan »

(Using MSO365)

I have a complex range for which I created a Named range. When I use that Name to create Conditional Formatting for that range, the Named Range entry converts to an (absolute) call address for the range.
I did some quick scans but it seems this is what others see too. Is that the case or am I missing something?

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Named range in Conditional Formatting

Post by HansV »

The conditional formatting engine hasn't been updated to handle named ranges.
Best wishes,
Hans