(I originally asked for "well-known" guidelines, but got no answers. In light of that I think it's fine is anyone just wants to answer with their own guidelines or a link to some they like.)
I have my own conventions, as I'm sure most other spreadsheet developers do. And I document them within my models. But I'm wondering if there are some guidelines or best practices that the wider community knows about that I'm not aware of.
Specifically, I just got to wondering if my usage of the "Linked Cell" style would confuse others. I use it to highlight cases when there is a value (usually from another worksheet) that I want to refer to in a formula, and I want it to appear near the place it's being used. So if I have a formula that looks like:
or more likely
the cell containing it gets a "Linked Cell" style. This distinguishes it from a regular calculation formula. That seems reasonable enough, and it's easy to explain, but of course "linked cell" could mean all kinds of things.
I don't need a big book of standards, but I was hoping Microsoft or one of the various "MVP" authorities have written about this. Something like the guidelines on how to use error values found at the bottom of this article:
EDIT: Here is what the menu with the "Data and Model" styles looks like: