This is a short guide to colour coding records in the client view using the filters menu.
+ Add New
.Settings
icon.Formatting
.New Rule
menu, select the column with the data you wish to apply the colour coding to, from the Apply to Column
drop down menu.Format Column if...
drop down menu.Text start with
to label any record that starts with a matching value to your rule.Value
box to match records against, where the values are strings such as text or number. This is a text entry box.Column Style
, or to colour the text, choose from the Text Style
palette.Apply Changes
to save your formatting rule.Add New Rule
from the Formatting
section of the Settings
menu to repeat this and add another rule.Below is an example screenshot of some temperature data formatted using the rule:
In this example, records in the Temperature
column whose value starts with
'1'
will be color coded green; records whose value starts with
'2'
will be colour coded yellow.
You can apply other formatting rules and styles to your data from this interface too!