Applying conditional formatting
Using conditional formatting, you can customize how cells display data in CRMRight data grids. You can even assign a grid characteristic (such as a color) to cells that contain data elements that meet special criteria. Conditional formatting allows you to call attention to important information. These visual alerts speed up users' ability to make decisions, thereby enabling them to use the grids to perform tasks more efficiently.
There are four types of conditions:
• Operator conditions
Use an Operator condition to change the appearance of a cell based on the information in that cell.
• Formula conditions
Use a Formula condition to change the appearance of a cell based on the information in another column.
• True conditions
Use a True condition to apply your cell formatting changes to every cell in a column.
• Condition Groups
Use a Condition Group to change the appearance of a cell based on more than one condition. The component conditions, joined by "AND" or "OR," can be the Operator, True, or Formula type. If you are using CRMRight version 17.10 or later, you can nest Condition Groups within Condition Groups.
Note: You must retrieve data before applying conditional formatting to a column.
