(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?
Named range in Conditional Formatting
-
- 5StarLounger
- Posts: 1185
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
-
- Administrator
- Posts: 78235
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Named range in Conditional Formatting
The conditional formatting engine hasn't been updated to handle named ranges.
Best wishes,
Hans
Hans