Format rules to highlight important data
Like the format rules of Excel and Google Sheets, AppSheet allows you to apply your own format rules, such as changing text colors and placing icons beside data in a specified column. You can apply the conditional format rule by using the AppSheet expression to change the app behavior dynamically, whether the format rule is applied or not, based on the contexts.
Creating a new format rule
The process to set up format rules is rather simple. Let’s create a new one.
Figure 3.31 – A list of the available format rule settings
Firstly, you need to name the rule. The name should be self-explanatory, as you may need to refer back to these rules later on. The name should give you a quick indication of the rule’s purpose. All format rules you make will reside on one table.
The other options are as follows:
- For this data: Select the name of the table where you intend to place the format rule...
