Conditional Formatting

The formatting is implemented using a formula on the Color property of the control. If the value being checked is ‘High’, then make the Color red. If not, then make the color Black.


I have a Display form. The ‘Priority’ field that I’m checking the value of is on card: DataCard6


With this information, I can change any of the Color properties for other controls to: If(DataCard6.Default.Value=”High”, Red, Black)


Note: for the card of the Priority field, I can alternatively use the following: If(Parent.Default.Value=”High”, Red, Black)


On the Browse screen, we access the data a little differently, so it looks like this: If(Priority.Value=”High”, Red, Black)


Regarding multiple values, like typical KPI (key performance indicator) examples – Red, Yellow, Green for example – you need to nest the formula logic like this: If(ReqType.Value=”Type1″, Red, If(ReqType.Value=”Type2″, Yellow, If(ReqType.Value=”Type3″, Green, Black)))