{"id":4645,"date":"2025-03-10T18:50:45","date_gmt":"2025-03-10T18:50:45","guid":{"rendered":"https:\/\/quebit.com\/askquebit\/?p=4645"},"modified":"2026-01-20T15:33:52","modified_gmt":"2026-01-20T15:33:52","slug":"member-formatting-in-planning-analytics-workspace","status":"publish","type":"post","link":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/","title":{"rendered":"How Do I Apply Member Formatting in Planning Analytics Workspace?"},"content":{"rendered":"

Member Formatting in Planning Analytics Workspace<\/strong><\/p>\n

Conditional formatting in MS Excel is\u00a0a feature that automatically formats cells based on their values.\u00a0This can include changing cell colors, borders, or font styles.\u00a0IBM Planning Analytics Workspace<\/a> (PAW) also offers conditional formatting capabilities, allowing you to highlight specific data points based on specific conditions (similar to how it works in MS Excel), allowing you to visually emphasize<\/em> important values by changing the looks of a cell based upon \u201crules\u201d you define.<\/p>\n

The new\u00a0Format manager\u00a0<\/a>(subject to enablement<\/a>)\u00a0by a Planning Analytics Workspace administrator), is a tool designed\u00a0to control the structure and layout of data within the Planning Analytics Workspace, allowing users to customize how information is presented in reports, dashboards, and other views, essentially providing a way to manage the visual formatting and organization of data for different users and scenarios within the platform.<\/p>\n

Try an Example<\/strong><\/p>\n

The following is a simple example of adding a conditional formatting rule to a data point within a Planning Analytics Workspace book<\/a>. After logging into Planning Analytics Workspace and opening a book (where you want to add the formatting), toggle the \u201cmode\u201d to EDIT:<\/p>\n

\"\"<\/p>\n

Once you are in EDIT mode, right-click on the column<\/u> in the view where you want to add your conditional formatting and then select \u201cMember format<\/strong>\u201d:<\/p>\n

\"\"<\/p>\n

The \u201cEdit <name of selected column> format<\/strong>\u201d dialog will be displayed. There will be three \u201csections\u201d listed on the left of the dialog: \u201cFormat data cells<\/strong>,\u201d \u201cFormat header cells<\/strong>\u201d and \u201cConditional data rules<\/strong>.\u201d Depending upon the data that will be in the cell, you may need to change the data cell format. For example, I have a cell that will display text data and want to add formatting based upon the value of that cell. To do that you need to set the data cell format to \u201cCustom format\u201d (to allow for a text rule to be applied to that cell).<\/p>\n

\"\"<\/p>\n

As shown above, I disabled the Inherit<\/strong> property by clicking the toggle to the off position since we do not want this cell to inherit any formatting from the corresponding Planning Analytics cube view. Next, I selected \u201cCustom Format<\/strong>\u201d from the drop-down selector and entered a \u201c#\u201d for the \u201cNumber Format<\/strong>\u201d value. Finally Apply <\/strong>was clicked.<\/p>\n

We can skip the \u201cFormat header cells<\/strong>\u201d section and go on to \u201cConditional data rules<\/strong>.\u201d In this section, click Add rule +<\/strong>, then modify the \u201cformatting rule\u201d that was added:<\/p>\n

\"\"<\/p>\n

There is an Order<\/strong> value (this is the rule precedence<\/em> or the order<\/em> in which the rule will be applied (if there is more than one rule created for this cell), similar to formatting rules in MS Excel. \u00a0Next, you will see Member<\/strong>. This is the member where I want to attach my rule (you can change the member value if you want or need to by selecting a different value from the drop-down selector). The Type<\/strong> will show as Text<\/em> (since we formatted the cell in the prior step to a custom format of text) for Operator<\/strong>, I selected \u201cEquals\u201d and for Value<\/strong> I enter a \u201cY.\u201d<\/p>\n

Finally, click on the ellipse icon<\/u> and then EDIT<\/strong> to add the customize formatting (border color, fill color, font style and color and even add an Indicator):<\/p>\n

\"\"<\/p>\n

Last step, click DONE<\/strong> then Apply<\/strong>, and refresh your page to view your work!<\/p>\n

\"\"<\/p>\n

The above (Format member<\/strong>) is a Format Manager<\/strong> shortcut<\/em>. You can access the full functionality of the Format Manager<\/a> by clicking the Format Manager icon in the cube view toolbar<\/a>:<\/p>\n

\"\"<\/p>\n

Ask QueBIT<\/strong><\/p>\n

Want some help with using formatting, conditional formatting and using the Format Manger to improve your Planning Analytics Workspace experience? Have a specific question? You can always reach out to QueBIT at\u00a0support@quebit.com<\/a>\u00a0for assistance. We\u2019re here to help!<\/p>\n","protected":false},"excerpt":{"rendered":"

Member Formatting in Planning Analytics Workspace Conditional formatting in MS Excel is\u00a0a feature that automatically formats cells based on their values.\u00a0This can include changing cell colors, borders, or font styles.\u00a0IBM Planning Analytics Workspace (PAW) also offers conditional formatting capabilities, allowing you to highlight specific data points based on specific conditions (similar to how it works…<\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[24],"tags":[108,51],"class_list":["post-4645","post","type-post","status-publish","format-standard","hentry","category-ibm","tag-ibm-planning-analytics","tag-planning-analytics-how-tos"],"acf":[],"yoast_head":"\nHow Do I Apply Member Formatting in Planning Analytics Workspace? - QueBIT<\/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:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How Do I Apply Member Formatting in Planning Analytics Workspace? - QueBIT\" \/>\n<meta property=\"og:description\" content=\"Member Formatting in Planning Analytics Workspace Conditional formatting in MS Excel is\u00a0a feature that automatically formats cells based on their values.\u00a0This can include changing cell colors, borders, or font styles.\u00a0IBM Planning Analytics Workspace (PAW) also offers conditional formatting capabilities, allowing you to highlight specific data points based on specific conditions (similar to how it works…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/\" \/>\n<meta property=\"og:site_name\" content=\"QueBIT\" \/>\n<meta property=\"article:published_time\" content=\"2025-03-10T18:50:45+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-01-20T15:33:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/03\/Picture1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"900\" \/>\n\t<meta property=\"og:image:height\" content=\"77\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Jennifer Field\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jennifer Field\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/\"},\"author\":{\"name\":\"Jennifer Field\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"headline\":\"How Do I Apply Member Formatting in Planning Analytics Workspace?\",\"datePublished\":\"2025-03-10T18:50:45+00:00\",\"dateModified\":\"2026-01-20T15:33:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/\"},\"wordCount\":638,\"commentCount\":0,\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Picture1.png\",\"keywords\":[\"IBM Planning Analytics\",\"Planning Analytics How To's\"],\"articleSection\":[\"IBM\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/\",\"name\":\"How Do I Apply Member Formatting in Planning Analytics Workspace? - QueBIT\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Picture1.png\",\"datePublished\":\"2025-03-10T18:50:45+00:00\",\"dateModified\":\"2026-01-20T15:33:52+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/#primaryimage\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Picture1.png\",\"contentUrl\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/wp-content\\\/uploads\\\/2025\\\/03\\\/Picture1.png\",\"width\":900,\"height\":77},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/member-formatting-in-planning-analytics-workspace\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How Do I Apply Member Formatting in Planning Analytics Workspace?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#website\",\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/\",\"name\":\"QueBIT\",\"description\":\"QueBIT\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/#\\\/schema\\\/person\\\/082a9c4156466b9cdad2632e3de62601\",\"name\":\"Jennifer Field\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g\",\"caption\":\"Jennifer Field\"},\"url\":\"https:\\\/\\\/quebit.com\\\/askquebit\\\/author\\\/quebit\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How Do I Apply Member Formatting in Planning Analytics Workspace? - QueBIT","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:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/","og_locale":"en_US","og_type":"article","og_title":"How Do I Apply Member Formatting in Planning Analytics Workspace? - QueBIT","og_description":"Member Formatting in Planning Analytics Workspace Conditional formatting in MS Excel is\u00a0a feature that automatically formats cells based on their values.\u00a0This can include changing cell colors, borders, or font styles.\u00a0IBM Planning Analytics Workspace (PAW) also offers conditional formatting capabilities, allowing you to highlight specific data points based on specific conditions (similar to how it works…","og_url":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/","og_site_name":"QueBIT","article_published_time":"2025-03-10T18:50:45+00:00","article_modified_time":"2026-01-20T15:33:52+00:00","og_image":[{"width":900,"height":77,"url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/03\/Picture1.png","type":"image\/png"}],"author":"Jennifer Field","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jennifer Field","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/#article","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/"},"author":{"name":"Jennifer Field","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"headline":"How Do I Apply Member Formatting in Planning Analytics Workspace?","datePublished":"2025-03-10T18:50:45+00:00","dateModified":"2026-01-20T15:33:52+00:00","mainEntityOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/"},"wordCount":638,"commentCount":0,"image":{"@id":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/03\/Picture1.png","keywords":["IBM Planning Analytics","Planning Analytics How To's"],"articleSection":["IBM"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/","url":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/","name":"How Do I Apply Member Formatting in Planning Analytics Workspace? - QueBIT","isPartOf":{"@id":"https:\/\/quebit.com\/askquebit\/#website"},"primaryImageOfPage":{"@id":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/#primaryimage"},"image":{"@id":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/#primaryimage"},"thumbnailUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/03\/Picture1.png","datePublished":"2025-03-10T18:50:45+00:00","dateModified":"2026-01-20T15:33:52+00:00","author":{"@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601"},"breadcrumb":{"@id":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/#primaryimage","url":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/03\/Picture1.png","contentUrl":"https:\/\/quebit.com\/askquebit\/wp-content\/uploads\/2025\/03\/Picture1.png","width":900,"height":77},{"@type":"BreadcrumbList","@id":"https:\/\/quebit.com\/askquebit\/member-formatting-in-planning-analytics-workspace\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/quebit.com\/askquebit\/"},{"@type":"ListItem","position":2,"name":"How Do I Apply Member Formatting in Planning Analytics Workspace?"}]},{"@type":"WebSite","@id":"https:\/\/quebit.com\/askquebit\/#website","url":"https:\/\/quebit.com\/askquebit\/","name":"QueBIT","description":"QueBIT","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/quebit.com\/askquebit\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/quebit.com\/askquebit\/#\/schema\/person\/082a9c4156466b9cdad2632e3de62601","name":"Jennifer Field","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/02bd32c7255ad906cd2c6352f643559cfee048a9b227b5b07b6a6f48d5b4a658?s=96&d=mm&r=g","caption":"Jennifer Field"},"url":"https:\/\/quebit.com\/askquebit\/author\/quebit\/"}]}},"_links":{"self":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4645","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/comments?post=4645"}],"version-history":[{"count":3,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4645\/revisions"}],"predecessor-version":[{"id":5050,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/posts\/4645\/revisions\/5050"}],"wp:attachment":[{"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/media?parent=4645"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/categories?post=4645"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/quebit.com\/askquebit\/wp-json\/wp\/v2\/tags?post=4645"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}