When your users interact with your app, or when you're using columns in your tables for formula etc, it's helpful to be able to spot at a glance which columns are formula-driven, and which ones take manual input.
Column naming convention:
For easier formula reference, I use the convention of adding underscore "_" to the start of the name. For user visibility: I also add "(ƒ)" to the end of the title
Conditional formatting (see image 2):
Create a new custom format using the "display" column Leave "contains" field blank Select the drowdown for which columns to format, and select all the formula ones (conveniently, they all have _underscore)