{"id":1626,"date":"2021-11-04T15:54:07","date_gmt":"2021-11-04T06:54:07","guid":{"rendered":"https:\/\/kintools.com\/?post_type=docs&#038;p=1626"},"modified":"2021-11-04T15:54:07","modified_gmt":"2021-11-04T06:54:07","password":"","slug":"expression-condition","status":"publish","type":"docs","link":"https:\/\/kintools.com\/en\/docs\/expression-condition\/","title":{"rendered":"Expression conditions"},"content":{"rendered":"<p class=\"wp-block-paragraph\">If you choose to use an expression condition, define a text expression that returns a boolean value. The returned value determines whether formatting is applied. The configuration panel is shown below.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/embim693.png\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" \/><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" width=\"13\" height=\"13\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/img_1.png\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 13px; --smush-placeholder-aspect-ratio: 13\/13;\"><strong>\u00a0field.<\/strong>field is used to select the type of condition.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/img_2.png\" width=\"13\" height=\"13\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 13px; --smush-placeholder-aspect-ratio: 13\/13;\"><strong>&nbsp;<\/strong><strong>Expression.<\/strong>This field is used to define an expression that should return a boolean value.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">for example,<strong>C#<\/strong>Suitable formula:<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Customers.CustomerName == \u201cMyCustomer\u201d<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The report generator cannot render conditional formatting if the expression cannot return a boolean value.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\"><img decoding=\"async\" data-src=\"https:\/\/www.stimulsoft.com\/en\/documentation\/online\/user-manual\/i.png\" width=\"11\" height=\"11\" alt=\"\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" class=\"lazyload\" style=\"--smush-placeholder-width: 11px; --smush-placeholder-aspect-ratio: 11\/11;\">&nbsp;<strong>important:<\/strong>The expression must return a boolean value. Otherwise the conditional formatting will fail.<\/p>","protected":false},"excerpt":{"rendered":"<p>\u5f0f\u6761\u4ef6\u306e\u4f7f\u7528\u3092\u9078\u629e\u3059\u308b\u5834\u5408\u306f\u3001\u30d6\u30fc\u30eb\u5024\u3092\u8fd4\u3059\u30c6\u30ad\u30b9\u30c8\u5f0f\u3092\u5b9a\u7fa9\u3057\u307e\u3059\u3002\u8fd4\u3055\u308c\u308b\u5024\u306b\u3088\u3063\u3066\u3001\u30d5\u30a9\u30fc\u30de\u30c3\u30c8\u304c\u9069\u7528\u3055\u308c [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ocean_post_layout":"","ocean_both_sidebars_style":"","ocean_both_sidebars_content_width":0,"ocean_both_sidebars_sidebars_width":0,"ocean_sidebar":"","ocean_second_sidebar":"","ocean_disable_margins":"enable","ocean_add_body_class":"","ocean_shortcode_before_top_bar":"","ocean_shortcode_after_top_bar":"","ocean_shortcode_before_header":"","ocean_shortcode_after_header":"","ocean_has_shortcode":"","ocean_shortcode_after_title":"","ocean_shortcode_before_footer_widgets":"","ocean_shortcode_after_footer_widgets":"","ocean_shortcode_before_footer_bottom":"","ocean_shortcode_after_footer_bottom":"","ocean_display_top_bar":"default","ocean_display_header":"default","ocean_header_style":"","ocean_center_header_left_menu":"","ocean_custom_header_template":"","ocean_custom_logo":0,"ocean_custom_retina_logo":0,"ocean_custom_logo_max_width":0,"ocean_custom_logo_tablet_max_width":0,"ocean_custom_logo_mobile_max_width":0,"ocean_custom_logo_max_height":0,"ocean_custom_logo_tablet_max_height":0,"ocean_custom_logo_mobile_max_height":0,"ocean_header_custom_menu":"","ocean_menu_typo_font_family":"","ocean_menu_typo_font_subset":"","ocean_menu_typo_font_size":0,"ocean_menu_typo_font_size_tablet":0,"ocean_menu_typo_font_size_mobile":0,"ocean_menu_typo_font_size_unit":"px","ocean_menu_typo_font_weight":"","ocean_menu_typo_font_weight_tablet":"","ocean_menu_typo_font_weight_mobile":"","ocean_menu_typo_transform":"","ocean_menu_typo_transform_tablet":"","ocean_menu_typo_transform_mobile":"","ocean_menu_typo_line_height":0,"ocean_menu_typo_line_height_tablet":0,"ocean_menu_typo_line_height_mobile":0,"ocean_menu_typo_line_height_unit":"","ocean_menu_typo_spacing":0,"ocean_menu_typo_spacing_tablet":0,"ocean_menu_typo_spacing_mobile":0,"ocean_menu_typo_spacing_unit":"","ocean_menu_link_color":"","ocean_menu_link_color_hover":"","ocean_menu_link_color_active":"","ocean_menu_link_background":"","ocean_menu_link_hover_background":"","ocean_menu_link_active_background":"","ocean_menu_social_links_bg":"","ocean_menu_social_hover_links_bg":"","ocean_menu_social_links_color":"","ocean_menu_social_hover_links_color":"","ocean_disable_title":"default","ocean_disable_heading":"default","ocean_post_title":"","ocean_post_subheading":"","ocean_post_title_style":"","ocean_post_title_background_color":"","ocean_post_title_background":0,"ocean_post_title_bg_image_position":"","ocean_post_title_bg_image_attachment":"","ocean_post_title_bg_image_repeat":"","ocean_post_title_bg_image_size":"","ocean_post_title_height":0,"ocean_post_title_bg_overlay":0.5,"ocean_post_title_bg_overlay_color":"","ocean_disable_breadcrumbs":"default","ocean_breadcrumbs_color":"","ocean_breadcrumbs_separator_color":"","ocean_breadcrumbs_links_color":"","ocean_breadcrumbs_links_hover_color":"","ocean_display_footer_widgets":"default","ocean_display_footer_bottom":"default","ocean_custom_footer_template":"","footnotes":""},"doc_category":[71],"doc_tag":[],"class_list":["post-1626","docs","type-docs","status-publish","hentry","doc_category-conditional-formatting","entry"],"year_month":"2026-05","word_count":6,"total_views":0,"reactions":{"happy":0,"normal":0,"sad":0},"author_info":{"name":"yuko.imai","author_nicename":"yuko-imai","author_url":"https:\/\/kintools.com\/en\/author\/yuko-imai\/"},"doc_category_info":[{"term_name":"\u6761\u4ef6\u4ed8\u304d\u66f8\u5f0f","term_url":"https:\/\/kintools.com\/en\/docs-category\/conditional-formatting\/"}],"doc_tag_info":[],"_links":{"self":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1626","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/comments?post=1626"}],"version-history":[{"count":1,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1626\/revisions"}],"predecessor-version":[{"id":1627,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/docs\/1626\/revisions\/1627"}],"wp:attachment":[{"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/media?parent=1626"}],"wp:term":[{"taxonomy":"doc_category","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_category?post=1626"},{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/kintools.com\/en\/wp-json\/wp\/v2\/doc_tag?post=1626"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}