Zoho Creator has helped you grasp information quickly with reports in the form of graphs and charts. Achieving this with data in tabular format is more challenging. Our new feature Conditional Formatting makes it possible.
With conditional formatting you can now color code your data in both list and spreadsheet view based on any criteria. The ability to automatically have certain data highlighted allows you to quickly and easily spot trends, outliers, or bring information to your attention. Read more
A chart makes it easy to see a trend over time or to compare how different figures stack up. To achieve a similar effect with plain tabular data is difficult, but not impossible! That’s what conditional formatting in Zoho Reports achieves.
Conditional Formatting of Tabular Data
You often see conditional formatting applied to financial data, where positive values are typically in green and negative values in red. A similar example below, where we show the best ‘CTR’s in green, the bad ones in red and the intermediate ones in yellow. You can apply color to the cell background and to the font (‘Clicks’ column in the below example).
Definitely easy to identify outliers and easy to comprehend, right? Zoho Reports now supports conditional formatting in base tables and query tables. We will be extending it to pivot and summary tables soon. You can access conditional formatting by right-clicking on a column.
Area and Stacked Area Charts
We have been continuously adding new chart types. The latest ones to come in are area and stacked area charts.
Try conditional formatting and area charts in Zoho Reports and let us know your feedback comments.