The formatting that may be applied is one of the following:<\/p>\n
- \n
- \n\t\tMake values on the output have a different color<\/li>\n
- \n\t\tMake the background color of a value on the output have a different color<\/li>\n
- \n\t\tMake the text of the value bold<\/li>\n
- \n\t\tMake the text of the value italic<\/li>\n
- \n\t\tPlace a colored dot within the cell that holds the value<\/li>\n
- \n\t\tConditionally hiding a value dependent on one or more conditions.<\/li>\n<\/ul>\n
More than one formatting value may be applied to a single value on the report, but it should be recognized that conflicts may arise. For example, you might want to place the following two conditional attributes within a report:<\/p>\n
- \n
- \n\t\tMake the background color of a cell colored blue, if the Category <\/em>field equals Software<\/em><\/li>\n
- \n\t\tMake the background color of the same cell red, if the Priority <\/em>field equals High.<\/em><\/li>\n<\/ul>\n
If both conditions are true, there is a conflict and only one of the conditional formatting attributes can be applied. No error will result, but only the first condition will be applied.<\/p>\n
\n\tCreating Conditional Formatting for Column & Treegrid Reports<\/h3>\n
Within the report editors, right-click on the small red button on a field selected for the report. If the field supports conditional formats, this button will appear:<\/p>\n
![](\"\/extraview-media\/images\/ug\/querying_reporting\/conditional-format-button.png\")
<\/p>\nClicking this button leads to a popup:<\/p>\n
![](\"\/extraview-media\/images\/ug\/querying_reporting\/conditional-format.png\")
<\/p>\nThe user may apply the conditional formatting as follows:<\/p>\n
- \n
- \n\t\tThe color of the text may be altered from the default black (#000000) color<\/li>\n
- \n\t\tThe color of the background to the value may be altered from the default white (#FFFFFF) color<\/span><\/li>\n
- \n\t\tThe text may be made bold<\/span><\/li>\n
- \n\t\tThe text may be italicized<\/span><\/li>\n
- \n\t\tA color dot or emoticon can be placed by the value, or instead of the value<\/li>\n
- \n\t\tUsing the * Hide Value If *<\/strong> option in the select list will cause the value to be hidden on the report output if it meets the condition.<\/li>\n<\/ul>\n
This shows conditional formatting being applied to a Column report:<\/p>\n
- \n
- \n\t\tEach Product has a different background color applied to the value<\/li>\n
- \n\t\tWhen the Status.of a product is Open<\/em> there is a red dot inserted.<\/li>\n<\/ul>\n
![\"\"](\"\/extraview-media\/images\/ug\/querying_reporting\/report-with-formatting.png\")
<\/p>\nYou may add multiple conditions for the selected field, using the
![](\"\/extraview-media\/images\/ug\/querying_reporting\/Plus.png\")
button. All conditions, except for the first, may be removed with the ![](\"\/extraview-media\/images\/ug\/querying_reporting\/Minus.png\")
button. When you click the ![](\"\/extraview-media\/images\/ug\/querying_reporting\/Down_arrow.png\")
button, you may apply a style for the field value, based on more complex conditions that are based on any fields. These complex conditions may be set for any formatting condition and look like this:<\/p>\n![](\"\/extraview-media\/images\/ug\/querying_reporting\/conditional-format-complex2.png\")
<\/p>\n\n\tCreating Conditional Formatting for Matrix & Summary Reports<\/h3>\n
The principals are similar to creating conditional formatting for Column and Treegrid reports, but with some distinct differences. First, you will typically create the formatting based upon the count of items on the report and secondly you may want to create conditional formats based on sub-totals, totals and the statistics computed in the results. As examples, you might want to format results based on these:<\/p>\n
- \n
- \n\t\tApply a format to any cell in the results when the count is greater or less than a number<\/li>\n
- \n\t\tApply a format to all of a row or column in the results when the count is greater or less than a number<\/li>\n
- \n\t\tApply a format to a total column, total row or both dependent upon the results.<\/li>\n<\/ul>\n
To initiate conditional formatting of results within matrix and summary tables, consider the following screenshot:<\/p>\n
![](\"\/extraview-media\/images\/ug\/querying_reporting\/matrix-report-conditional-format.png\")
<\/p>\nThe user has chosen to add statistics in the form of Totals <\/strong>and Percentages<\/strong>. The screenshot further shows that having clicked on the Total <\/strong>label, the user has set a Title <\/strong>of Total<\/em>, a Precision <\/strong>of ### <\/em>and that the statistics should be applied to both axes<\/strong>. These choices led to the area of the screen titled Format Statistics and Aggregation Fields<\/strong> being populated with entries allowing the user to optionally apply conditional formats to the appropriate statistics of the report output, The user may then right-click on any of these statistics to apply conditional formats:<\/p>\n
![](\"\/extraview-media\/images\/ug\/querying_reporting\/conditional-format-statistics2.png\")
<\/p>\nYou may add multiple conditions for the selected field, using the <\/span>
button. All conditions, except for the first, may be removed with the <\/span> button. When you click the <\/span> button, you may apply a style for the field value, based on more complex conditions that are based on any fields. These complex conditions may be set for any formatting condition. <\/span>You may base the conditional format on the value of the result, selecting an operator, a value and the format. <\/p>\nThe user may apply the conditional formatting as follows:<\/p>\n
- \n
- \n\t\tThe color of the text may be altered from the default black (#000000) color<\/li>\n
- \n\t\tThe color of the background to the value may be altered from the default white (#FFFFFF) color<\/span><\/li>\n
- \n\t\tThe text may be made bold<\/span><\/li>\n
- \n\t\tThe text may be italicized<\/span><\/li>\n
- \n\t\tA color dot or emoticon can be placed by the value, or instead of the value.<\/li>\n<\/ul>\n
\n\tConditional Formatting on Time Periods and Historic Data<\/h3>\n
It is sometimes useful to be able to provide conditional formatting on data that has changed within a specific period. For example, you might want to provide the formatting on values that changed within the last week. This is accomplished with a complex filter as shown above, and using the changed<\/em> operator. As an example, this screenshot displays how to provide a green background on Assigned To<\/strong> values that changed in the last 7 days:<\/p>\n
![](\"\/extraview-media\/images\/ug\/querying_reporting\/conditional-date-range.png\")
<\/p>\n\n\tResolving Conflicts<\/h3>\n
It is entirely possible that you might set up conflicting conditional formatting attributes. For example, you might set up a conditional formatting attribute that sets a background color when a specific condition is met. Another conditional formatting attribute on the same field might require a different background color to be set for a different filter condition. ExtraView will use the first specified conflicting attribute. In some cases, this can be an advantage, for example when you wish to set up ranges, according to counts within your report.<\/p>\n
In this example, we want to establish background colors as follows:<\/p>\n
\n\n
\n \n\t\t\t\tRange<\/td>\n \n\t\t\t\tColor<\/td>\n<\/tr>\n \n \n\t\t\t\tLess than, or equal to 7<\/td>\n \n\t\t\t\tGreen<\/td>\n<\/tr>\n \n \n\t\t\t\tGreater than, or equal to 7 but less than 11<\/td>\n \n\t\t\t\tPurple<\/td>\n<\/tr>\n \n \n\t\t\t\tGreater than 11<\/td>\n \n\t\t\t\tRed<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n To take advantage of the fact that the attributes in the list are processed in order and the earliest one in the list is used when there is a conflict, you set the attributes as follows. The order is important:<\/p>\n
![](\"\/extraview-media\/images\/ug\/querying_reporting\/formatting-range2.png\")
<\/p>\n\n\tLimitations<\/h3>\n
- \n
- \n\t\tOutput to Text<\/strong> – No conditional formatting is applied<\/li>\n
- \n\t\tOutput to Microsoft Excel (Plain output)<\/strong> – No conditional formatting is applied<\/span><\/li>\n
- \n\t\tOutput to PDF and Container Reports<\/strong> – Conditional formatting is not supported. It is expected that this limitation will be removed in a future release<\/span><\/li>\n
- \n\t\tOutput to Microsoft Excel (Formatted output)<\/strong> – Not all colored dots can be rendered. A marker is used within the output for those that cannot be displayed.<\/span><\/li>\n<\/ul>\n
<\/p>\n","protected":false},"excerpt":{"rendered":"
Conditional formatting of the results on report output can accomplish many criteria. The formatting attributes may be applied to these report types: Column reports Summary reports Matrix reports Treegrid reports. The formatting that may be applied is one of the following: Make values on the output have a different color Make the background color of…<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"","_lmt_disable":"","_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"class_list":["post-21991","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"\n
Conditional Formatting of Results - Product Documentation<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conditional Formatting of Results - Product Documentation\" \/>\n<meta property=\"og:description\" content=\"Conditional formatting of the results on report output can accomplish many criteria. The formatting attributes may be applied to these report types: Column reports Summary reports Matrix reports Treegrid reports. The formatting that may be applied is one of the following: Make values on the output have a different color Make the background color of...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/\",\"url\":\"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/\",\"name\":\"Conditional Formatting of Results - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#website\"},\"datePublished\":\"2024-02-15T22:48:40+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v22\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Conditional Formatting of Results\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v22\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v22\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v22\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"contentUrl\":\"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png\",\"width\":512,\"height\":512,\"caption\":\"ExtraView Corporation\"},\"image\":{\"@id\":\"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conditional Formatting of Results - Product Documentation","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/","og_locale":"en_US","og_type":"article","og_title":"Conditional Formatting of Results - Product Documentation","og_description":"Conditional formatting of the results on report output can accomplish many criteria. The formatting attributes may be applied to these report types: Column reports Summary reports Matrix reports Treegrid reports. The formatting that may be applied is one of the following: Make values on the output have a different color Make the background color of...","og_url":"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/","og_site_name":"Product Documentation","twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/","url":"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/","name":"Conditional Formatting of Results - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v22\/#website"},"datePublished":"2024-02-15T22:48:40+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v22\/conditional-formatting-results\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v22\/"},{"@type":"ListItem","position":2,"name":"Conditional Formatting of Results"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v22\/#website","url":"https:\/\/docs.extraview.com\/v22\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v22\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v22\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v22\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v22\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/","url":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","contentUrl":"https:\/\/docs-stg.extraview.com\/wp-content\/uploads\/2024\/03\/favicon.png","width":512,"height":512,"caption":"ExtraView Corporation"},"image":{"@id":"https:\/\/docs.extraview.com\/v22\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v22\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages\/21991","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/comments?post=21991"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/pages\/21991\/revisions"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v22\/wp-json\/wp\/v2\/media?parent=21991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} - \n\t\tOutput to Microsoft Excel (Plain output)<\/strong> – No conditional formatting is applied<\/span><\/li>\n
- \n\t\tThe text may be made bold<\/span><\/li>\n
- \n\t\tThe text may be made bold<\/span><\/li>\n
- \n\t\tMake the background color of the same cell red, if the Priority <\/em>field equals High.<\/em><\/li>\n<\/ul>\n
- \n\t\tMake the background color of a cell colored blue, if the Category <\/em>field equals Software<\/em><\/li>\n