Apply conditional formatting

2:22 min

Learn how to use conditional formatting to quickly highlight key values in the grid. In Flex Modes, you can apply rules that change the text or background color based on cell values. It’s a great way to make trends and outliers stand out without needing to sort or filter.

Supporting documentation

Phocas product

Flex Modes

Category

Customize views

Tags

Format Grid Customize

Help & support

Have questions or need to report an issue with a Phocas product?

Get support

Related video tutorials

Analytics

Add levels (grid nesting)

Learn how to bring together related data from different dimensions as an expandable report in the Phocas grid using the 'nest' feature. Grid nesting allows you to display up to three levels of detail, grouped by dimension.

1:59 min

Flex Modes

Manage grid settings

Learn how Grid settings help you control what appears in the grid and how your data is presented. Adjust the period order, include or exclude items based on activity, and refine date-related settings to focus the grid on the results that are most relevant to your analysis.

2:41 min

Flex Modes

Work with the grid

Learn how to work efficiently with the grid. This tutorial shows you how to sort data, freeze properties, navigate larger result sets, use grid actions and shortcuts, and quickly calculate values from selected data.

2:54 min

Flex Modes

Create a nested view

With the nest view feature in Flex Modes, you can add dimensions as levels in the grid, making your data easier to interpret. This lets you see how different items contribute to the overall results and build reports where you define the hierarchy of the data on display.

1:54 min