The built-in functionality allows you to double-click or click F2 and see all precedents highlighted, but only on the same sheet as the formula. This solution applies fill color to all immediate precedent cells on all sheets, and presents a UserForm to select which sheet to activate. Then closing the form restores the original formatting.
See release notes for limitations. Also, it shows only immediate precedents, and not precedents of precedents.
Consider this a beta test. I would be happy to entertain suggestions for corrections and enhancements.
Bookmarks