@Steve Kraynak
Just because something is difficult does not mean it should not be pursued.
If all companies had that mentality we would never progress.
So I ask my original question yet again.
Are you able to shed any light on when the Conditional Formatting applied to named ranges is likely to be incorporated into future versions?
It would be great to understand where this is in the Excel teams Road-Map as it is one of the most voted items, has been open since 2015 and still has a status of "Not at this time".
https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10561194-conditional-formatting-apply-to-named-ranges?tracking_code=f015379b2ae2bf966f435f01df692cb9
Would be nice if Microsoft focus on actual voted items, especially those in the top 10.