{"id":23805,"date":"2024-02-15T14:53:34","date_gmt":"2024-02-15T22:53:34","guid":{"rendered":"https:\/\/docs.extraview.com\/v25\/book\/conditional-formatting-results-1\/"},"modified":"2025-03-06T11:40:21","modified_gmt":"2025-03-06T19:40:21","slug":"conditional-formatting-results-1","status":"publish","type":"page","link":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/","title":{"rendered":"Conditional Formatting of Results"},"content":{"rendered":"<p>Conditional formatting of the results on report output can accomplish many criteria.\u00a0 The formatting attributes may be applied to these report types:<\/p>\n<ul>\n<li>Column reports<\/li>\n<li>Summary reports<\/li>\n<li>Matrix reports<\/li>\n<li>Treegrid reports.<\/li>\n<\/ul>\n<p>The formatting that may be applied is one of the following:<\/p>\n<ul>\n<li>Make values on the output have a different color<\/li>\n<li>Make the background color of a value on the output have a different color<\/li>\n<li>Make the text of the value bold<\/li>\n<li>Make the text of the value italic<\/li>\n<li>Place a colored dot within the cell that holds the value<\/li>\n<li>Conditionally hiding a value dependent on one or more conditions.<\/li>\n<\/ul>\n<p>More than one formatting value may be applied to a single value on the report, but it should be recognized that conflicts may arise.\u00a0 For example, you might want to place the following two conditional attributes within a report:<\/p>\n<ul>\n<li>Make the background color of a cell colored blue, if the <em>Category <\/em>field equals <em>Software<\/em><\/li>\n<li>Make the background color of the same cell red, if the <em>Priority <\/em>field equals <em>High.<\/em><\/li>\n<\/ul>\n<p>If both conditions are true, there is a conflict and only one of the conditional formatting attributes can be applied.\u00a0 No error will result, but only the first condition will be applied.<\/p>\n<h3>Creating Conditional Formatting for Column &amp; Treegrid Reports<\/h3>\n<p>Within the report editors, right-click on the small red button on a field selected for the report.\u00a0 If the field supports conditional formats, this button will appear:<\/p>\n<p><img decoding=\"async\" style=\"width: 500px;\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/conditional-format-button.png\" \/><\/p>\n<p>Clicking this button leads to a popup:<\/p>\n<p><img decoding=\"async\" style=\"width: 90%;\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/conditional-format.png\" \/><\/p>\n<p>The user may apply the conditional formatting as follows:<\/p>\n<ul>\n<li>The color of the text may be altered from the default black (#000000) color<\/li>\n<li>The color of the background to the value may be altered from the default white (#FFFFFF) color<\/li>\n<li>The text may be made bold<\/li>\n<li>The text may be italicized<\/li>\n<li>A color dot or emoticon can be placed by the value, or instead of the value<\/li>\n<li>Using the <strong>* 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<p>This shows conditional formatting being applied to a Column report:<\/p>\n<ul>\n<li>Each Product has a different background color applied to the value<\/li>\n<li>When the Status of a product is <em>Open<\/em> there is a red dot inserted.<\/li>\n<\/ul>\n<p><img decoding=\"async\" style=\"width: 90%;\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/report-with-formatting.png\" alt=\"\" \/><\/p>\n<p>You may add multiple conditions for the selected field, using the <img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/Plus.png\" \/> button.\u00a0 All conditions, except for the first, may be removed with the <img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/minus.png\" \/> button.\u00a0 When you click the <img decoding=\"async\" src=\"\/v25\/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.\u00a0 These complex conditions may be set for any formatting condition and look like this:<\/p>\n<p><img decoding=\"async\" style=\"width: 90%;\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/conditional-format-complex2.png\" \/><\/p>\n<h3>Creating Conditional Formatting for Matrix &amp; Summary Reports<\/h3>\n<p>The principals are similar to creating conditional formatting for Column and Treegrid reports, but with some distinct differences.\u00a0 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.\u00a0 As examples, you might want to format results based on these:<\/p>\n<ul>\n<li>Apply a format to any cell in the results when the count is greater or less than a number<\/li>\n<li>Apply a format to all of a row or column in the results when the count is greater or less than a number<\/li>\n<li>Apply a format to a total column, total row or both dependent upon the results.<\/li>\n<\/ul>\n<p>To initiate conditional formatting of results within matrix and summary tables, consider the following screenshot:<\/p>\n<p><img decoding=\"async\" style=\"width: 90%;\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/matrix-report-conditional-format.png\" \/><\/p>\n<p>The user has chosen to add statistics in the form of <strong>Totals <\/strong>and <strong>Percentages<\/strong>.\u00a0 The screenshot further shows that having clicked on the <strong>Total <\/strong>label, the user has set a <strong>Title <\/strong>of <em>Total<\/em>, a <strong>Precision <\/strong>of <em>### <\/em>and that the statistics should be applied to both <strong>axes<\/strong>.\u00a0 These choices led to the area of the screen titled <strong>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<p><img decoding=\"async\" style=\"width: 90%;\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/conditional-format-statistics2.png\" \/><\/p>\n<p>You may add multiple conditions for the selected field, using the <img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/Plus.png\" \/> button.\u00a0 All conditions, except for the first, may be removed with the <img decoding=\"async\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/minus.png\" \/> button.\u00a0 When you click the <img decoding=\"async\" src=\"\/v25\/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.\u00a0 These complex conditions may be set for any formatting condition.\u00a0You may base the conditional format on the value of the result, selecting an operator, a value and the format.<\/p>\n<p>The user may apply the conditional formatting as follows:<\/p>\n<ul>\n<li>The color of the text may be altered from the default black (#000000) color<\/li>\n<li>The color of the background to the value may be altered from the default white (#FFFFFF) color<\/li>\n<li>The text may be made bold<\/li>\n<li>The text may be italicized<\/li>\n<li>A color dot or emoticon can be placed by the value, or instead of the value.<\/li>\n<\/ul>\n<h3>Conditional Formatting on Time Periods and Historic Data<\/h3>\n<p>It is sometimes useful to be able to provide conditional formatting on data that has changed within a specific period.\u00a0 For example, you might want to provide the formatting on values that changed within the last week.\u00a0 This is accomplished with a complex filter as shown above and using the <em>changed<\/em> operator.\u00a0 As an example, this screenshot displays how to provide a green background on\u00a0<strong>Assigned To<\/strong> values that changed in the last 7 days:<\/p>\n<p><img decoding=\"async\" style=\"width: 90%;\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/conditional-date-range.png\" \/><\/p>\n<h3>Resolving Conflicts<\/h3>\n<p>It is entirely possible that you might set up conflicting conditional formatting attributes.\u00a0 For example, you might set up a conditional formatting attribute that sets a background color when a specific condition is met.\u00a0 Another conditional formatting attribute on the same field might require a different background color to be set for a different filter condition.\u00a0 ExtraView will use the first specified conflicting attribute.\u00a0 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<p>In this example, we want to establish background colors as follows:<\/p>\n<table border=\"0\" cellspacing=\"2\" cellpadding=\"2\">\n<tbody>\n<tr>\n<td style=\"background-color: #cccccc; width: 300px;\">Range<\/td>\n<td style=\"background-color: #cccccc; width: 100px;\">Color<\/td>\n<\/tr>\n<tr>\n<td>Less than, or equal to 7<\/td>\n<td>Green<\/td>\n<\/tr>\n<tr>\n<td>Greater than, or equal to 7 but less than 11<\/td>\n<td>Purple<\/td>\n<\/tr>\n<tr>\n<td>Greater than 11<\/td>\n<td>Red<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>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.\u00a0 The order is important:<\/p>\n<p><img decoding=\"async\" style=\"background-color: transparent; color: #333333; cursor: default; font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 12px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; text-align: left; text-decoration: none; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; word-spacing: 0px; width: 90%;\" src=\"\/v25\/extraview-media\/images\/ug\/querying_reporting\/formatting-range2.png\" \/><\/p>\n<h3>Limitations<\/h3>\n<ul>\n<li><strong>Output to Text<\/strong> &#8211; No conditional formatting is applied<\/li>\n<li><strong>Output to Microsoft Excel (Plain output)<\/strong> &#8211;\u00a0No conditional formatting is applied<\/li>\n<li><strong>Output to PDF and Container Reports<\/strong> &#8211; Conditional formatting is not supported.\u00a0 It is expected that this limitation will be removed in a future release<\/li>\n<li><strong>Output to Microsoft Excel (Formatted output)<\/strong> &#8211; Not all colored dots can be rendered.\u00a0 A marker is used within the output for those that cannot be displayed.<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Conditional formatting of the results on report output can accomplish many criteria.\u00a0 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&#8230;<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":23802,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"","meta":{"_acf_changed":false,"_lmt_disableupdate":"no","_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-23805","page","type-page","status-publish","hentry"],"acf":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>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\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/\" \/>\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.\u00a0 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\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/\" \/>\n<meta property=\"og:site_name\" content=\"Product Documentation\" \/>\n<meta property=\"article:modified_time\" content=\"2025-03-06T19:40:21+00:00\" \/>\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\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/\",\"url\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/\",\"name\":\"Conditional Formatting of Results - Product Documentation\",\"isPartOf\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\"},\"datePublished\":\"2024-02-15T22:53:34+00:00\",\"dateModified\":\"2025-03-06T19:40:21+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"ExtraView 25\",\"item\":\"https:\/\/docs.extraview.com\/v25\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"End User Guide\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/\"},{\"@type\":\"ListItem\",\"position\":4,\"name\":\"Reporting\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/\"},{\"@type\":\"ListItem\",\"position\":5,\"name\":\"Common Report Functions\",\"item\":\"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/\"},{\"@type\":\"ListItem\",\"position\":6,\"name\":\"Conditional Formatting of Results\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#website\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"name\":\"ExtraView Product Documentation\",\"description\":\"ExtraView Documentation\",\"publisher\":{\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#organization\",\"name\":\"ExtraView Corporation\",\"url\":\"https:\/\/docs.extraview.com\/v25\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/docs.extraview.com\/v25\/#\/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\/v25\/#\/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\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/","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.\u00a0 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\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/","og_site_name":"Product Documentation","article_modified_time":"2025-03-06T19:40:21+00:00","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\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/","url":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/","name":"Conditional Formatting of Results - Product Documentation","isPartOf":{"@id":"https:\/\/docs.extraview.com\/v25\/#website"},"datePublished":"2024-02-15T22:53:34+00:00","dateModified":"2025-03-06T19:40:21+00:00","breadcrumb":{"@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/conditional-formatting-results-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":2,"name":"ExtraView 25","item":"https:\/\/docs.extraview.com\/v25\/"},{"@type":"ListItem","position":3,"name":"End User Guide","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/"},{"@type":"ListItem","position":4,"name":"Reporting","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/"},{"@type":"ListItem","position":5,"name":"Common Report Functions","item":"https:\/\/docs.extraview.com\/v25\/extraview-25\/end-user-guide-1\/reporting-1\/common-report-functions-1\/"},{"@type":"ListItem","position":6,"name":"Conditional Formatting of Results"}]},{"@type":"WebSite","@id":"https:\/\/docs.extraview.com\/v25\/#website","url":"https:\/\/docs.extraview.com\/v25\/","name":"ExtraView Product Documentation","description":"ExtraView Documentation","publisher":{"@id":"https:\/\/docs.extraview.com\/v25\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/docs.extraview.com\/v25\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/docs.extraview.com\/v25\/#organization","name":"ExtraView Corporation","url":"https:\/\/docs.extraview.com\/v25\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/docs.extraview.com\/v25\/#\/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\/v25\/#\/schema\/logo\/image\/"}}]}},"taxonomy_info":[],"featured_image_src_large":false,"author_info":{"display_name":"carl.koppel","author_link":"https:\/\/docs.extraview.com\/v25\/author\/carl-koppel\/"},"comment_info":0,"_links":{"self":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23805","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/comments?post=23805"}],"version-history":[{"count":0,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23805\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/pages\/23802"}],"wp:attachment":[{"href":"https:\/\/docs.extraview.com\/v25\/wp-json\/wp\/v2\/media?parent=23805"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}