{"id":23833,"date":"2020-09-23T15:37:05","date_gmt":"2020-09-23T14:37:05","guid":{"rendered":"https:\/\/support.ospreyapproach.com\/?post_type=pracctice_guide&#038;p=23833"},"modified":"2024-12-19T15:01:12","modified_gmt":"2024-12-19T15:01:12","slug":"report-writer-conditional-formatting","status":"publish","type":"pracctice_guide","link":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/","title":{"rendered":"Conditional Formatting"},"content":{"rendered":"<div class=\"card\">\n\n    <p class=\"mb-2\"><strong>Who is this guide for?<\/strong><\/p>\n    <p class=\"mb-0\"><i class=\"far fa-user fa-fw mr-2\"><\/i> <strong>Accounts Supervisors<\/strong>, <strong>System Supervisors<\/strong> and <strong>Report Writers<\/strong><\/p>    \n<\/div>\n\n\n\n<h2 class=\"wp-block-heading\">This guide will take you through using conditional formatting when creating reports<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Any reports you have written for your company can be set to display with Conditional Formatting &#8211; this enables you to highlight entries on reports based on specific criteria. Examples may be to highlight monetary values below a certain amount, or dates earlier than a particular date.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">In the example below, we are using an introducer report to calculate the amounts of commission paid to each introducer. This amount is based on the fee quoted to the client. The conditional formatting will be set to highlight matters where the fee quoted has not been entered. <\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Open the report you wish to add the conditional formatting to.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1916\" height=\"1003\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/open-report.gif\" alt=\"\" class=\"wp-image-23834\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Select the field you wish to change the formatting of, dependent on the conditions. Click the chevron button in the top right hand corner of the field, and select the ellipsis (&#8230;) button alongside Formatting Rules. Then click Edit Rule Sheet.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1916\" height=\"1003\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/open-collection-editor.gif\" alt=\"\" class=\"wp-image-23835\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Click the + button to add a new formatting rule. On the right hand side of the resulting box, click the ellipsis (&#8230;) button alongside Condition.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1916\" height=\"1003\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/add-formatting-rule-1.gif\" alt=\"\" class=\"wp-image-23862\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Use the condition editor to enter the condition for which you&#8217;d like to format your field differently. In this example we will look for a Fee Quoted of 0 and apply a format to it.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1916\" height=\"1003\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/add-condition.gif\" alt=\"\" class=\"wp-image-23863\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now, set the format to apply to that condition (the box on the bottom right shows the result of your formatting): <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1916\" height=\"1003\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/set-format.gif\" alt=\"\" class=\"wp-image-23875\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now give your conditional format a more explanatory name, press return and click Close: <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1916\" height=\"1003\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/name-it.gif\" alt=\"\" class=\"wp-image-23876\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">To apply this conditional format to the field, move the new rule you have created into the Rules applied to a control box on the right, by selecting and using the single &gt; button. Click OK: <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"1916\" height=\"1003\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/apply-it.gif\" alt=\"\" class=\"wp-image-23877\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">Now preview your report. The Fee Quoted field now appears in red text if it is zero: <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"325\" src=\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/image-51-1024x325.png\" alt=\"\" class=\"wp-image-23878\" srcset=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2020\/09\/image-51-1024x325.png 1024w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2020\/09\/image-51-300x95.png 300w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2020\/09\/image-51-768x243.png 768w, https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2020\/09\/image-51.png 1139w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This guide will take you through using conditional formatting when creating reports Any reports you have written for your company can be set to display with Conditional Formatting &#8211; this enables you to highlight entries on reports based on specific criteria. Examples may be to highlight monetary values below a certain amount, or dates earlier [&hellip;]<\/p>\n","protected":false},"author":24,"featured_media":0,"template":"","categories":[127],"tags":[],"class_list":["post-23833","pracctice_guide","type-pracctice_guide","status-publish","hentry","category-supervisor-report-writer"],"acf":{"display_as_dashboard_announcement":false,"announcement_title":"","announcement_type":"New feature","announcement_link_text":"Learn more","announcement_image":null},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Conditional Formatting - Osprey Approach Customer Support &amp; Training | Osprey Academy<\/title>\n<meta name=\"description\" content=\"Step by step guide for adding conditional formatting to your custom reports. This enables you to highlight entries based on certain criteria.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Conditional Formatting - Osprey Approach Customer Support &amp; Training | Osprey Academy\" \/>\n<meta property=\"og:description\" content=\"Step by step guide for adding conditional formatting to your custom reports. This enables you to highlight entries based on certain criteria.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/\" \/>\n<meta property=\"og:site_name\" content=\"Osprey Approach Customer Support &amp; Training | Osprey Academy\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/OspreyApproachUK\/\" \/>\n<meta property=\"article:modified_time\" content=\"2024-12-19T15:01:12+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2020\/09\/open-report.gif\" \/>\n\t<meta property=\"og:image:width\" content=\"1916\" \/>\n\t<meta property=\"og:image:height\" content=\"1003\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/gif\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:site\" content=\"@OspreyApproach\" \/>\n<meta name=\"twitter:label1\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/\",\"name\":\"Conditional Formatting - Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"isPartOf\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/open-report.gif\",\"datePublished\":\"2020-09-23T14:37:05+00:00\",\"dateModified\":\"2024-12-19T15:01:12+00:00\",\"description\":\"Step by step guide for adding conditional formatting to your custom reports. This enables you to highlight entries based on certain criteria.\",\"breadcrumb\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/#primaryimage\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/open-report.gif\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/open-report.gif\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/support.ospreyapproach.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Guides\",\"item\":\"https:\/\/support.ospreyapproach.com\/guides\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Conditional Formatting\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"name\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization\",\"name\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\",\"url\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"contentUrl\":\"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png\",\"width\":201,\"height\":61,\"caption\":\"Osprey Approach Customer Support &amp; Training | Osprey Academy\"},\"image\":{\"@id\":\"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/OspreyApproachUK\/\",\"https:\/\/x.com\/OspreyApproach\",\"https:\/\/www.linkedin.com\/company\/ospreyapproach\",\"https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Conditional Formatting - Osprey Approach Customer Support &amp; Training | Osprey Academy","description":"Step by step guide for adding conditional formatting to your custom reports. This enables you to highlight entries based on certain criteria.","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:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/","og_locale":"en_GB","og_type":"article","og_title":"Conditional Formatting - Osprey Approach Customer Support &amp; Training | Osprey Academy","og_description":"Step by step guide for adding conditional formatting to your custom reports. This enables you to highlight entries based on certain criteria.","og_url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/","og_site_name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","article_publisher":"https:\/\/www.facebook.com\/OspreyApproachUK\/","article_modified_time":"2024-12-19T15:01:12+00:00","og_image":[{"width":1916,"height":1003,"url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/content\/uploads\/sites\/2\/2020\/09\/open-report.gif","type":"image\/gif"}],"twitter_card":"summary_large_image","twitter_site":"@OspreyApproach","twitter_misc":{"Estimated reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/","name":"Conditional Formatting - Osprey Approach Customer Support &amp; Training | Osprey Academy","isPartOf":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website"},"primaryImageOfPage":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/#primaryimage"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/#primaryimage"},"thumbnailUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/open-report.gif","datePublished":"2020-09-23T14:37:05+00:00","dateModified":"2024-12-19T15:01:12+00:00","description":"Step by step guide for adding conditional formatting to your custom reports. This enables you to highlight entries based on certain criteria.","breadcrumb":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/#primaryimage","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/open-report.gif","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2020\/09\/open-report.gif"},{"@type":"BreadcrumbList","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/guides\/report-writer-conditional-formatting\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/support.ospreyapproach.com\/"},{"@type":"ListItem","position":2,"name":"Guides","item":"https:\/\/support.ospreyapproach.com\/guides\/"},{"@type":"ListItem","position":3,"name":"Conditional Formatting"}]},{"@type":"WebSite","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#website","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","description":"","publisher":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":"Organization","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#organization","name":"Osprey Approach Customer Support &amp; Training | Osprey Academy","url":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/","logo":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/","url":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","contentUrl":"https:\/\/support.ospreyapproach.com\/content\/uploads\/sites\/2\/2021\/10\/Osprey-Logo-200px.png","width":201,"height":61,"caption":"Osprey Approach Customer Support &amp; Training | Osprey Academy"},"image":{"@id":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/OspreyApproachUK\/","https:\/\/x.com\/OspreyApproach","https:\/\/www.linkedin.com\/company\/ospreyapproach","https:\/\/www.youtube.com\/channel\/UClARKUq_3YvaK01GPvI6_qA"]}]}},"_links":{"self":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/23833","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide"}],"about":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/types\/pracctice_guide"}],"author":[{"embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/users\/24"}],"version-history":[{"count":3,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/23833\/revisions"}],"predecessor-version":[{"id":69042,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/pracctice_guide\/23833\/revisions\/69042"}],"wp:attachment":[{"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/media?parent=23833"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/categories?post=23833"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ospreyapproach2022.wireddemo.co.uk\/support\/wp-json\/wp\/v2\/tags?post=23833"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}