3 ms·
The first rule of Excel is to expect immense frustration. Named ranges and tables can't be used as conditional formatting targets, Excel just converts them to
by ultrabenos 8y ago
The first rule of Excel is to expect immense frustration.
Named ranges and tables can't be used as conditional formatting targets, Excel just converts them to absolute cell references right before your eyes. Even if you use INDIRECT.
Most formula errors result in #N/A, a generic error which never has anything remotely useful in the Excel help articles. You have to waste time searching keyword by keyword until you accidentally get the right combination to display relevant SO or obscure forum links from over 3 years ago.