Conditional Formatting :) ... :(

I love the concept of Conditional Formatting and I try to use it frequently but its a love/hate relationship.

Recently I upgraded from 2010 to 2016 as the new formulas (maxifs, etc) were a help in getting rid of some array functions.  I was hoping that there would be updates to address the hate part of the love/hate relationship with Conditional Formatting to no avail.  MS needs to take conditional formatting to the next step and make the entry/edit box for conditional formatting formulas work like a true cell with predictive functions, identification of errors in function construction, allow table references, allow the Find function to look in conditional formatting formulas, etc.  I've wasted more time looking through conditional formatting to find invalid references and references to tabs or ranges where the name has changed that I care to discuss.  Its time to bring Conditional Formatting up to a real usable feature.