--- title: "What is Conditional Formatting: A Free Add-On for your Kintone Experience" description: The Conditional Formatting add-on allows you to change the text color, background color, and text size of fields, depending on the values of a specific field. image: https://blog.kintone.com/hubfs/How%20To%20Blog%20Image/3.png --- [![Kintone](https://blog.kintone.com/hubfs/KintoneGlobal/svg/logo_kinton_black.svg)](https://www.kintone.com/en-us/) [![Kintone](https://blog.kintone.com/hubfs/KintoneGlobal/svg/logo_kinton_black.svg)](https://www.kintone.com/en-us/) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_search_black.svg) - Product Product![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg)![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - Product ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Intro to Kintone](https://www.kintone.com/en-us/intro/) - [Why Kintone](https://www.kintone.com/en-us/why-kintone/) - Features ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [How Kintone Works](https://www.kintone.com/en-us/how-kintone-works/) - [App Template Library](https://www.kintone.com/en-us/features/app-templates/) - [Extensions](https://www.kintone.com/en-us/features/extensions/) - [Native Kintone Plug-ins](https://www.kintone.com/en-us/features/plugins/) - [Kintone AI](https://www.kintone.com/en-us/features/ai/) - [System Administration](https://www.kintone.com/en-us/features/administration/) - [Security](https://www.kintone.com/en-us/security/) - Solutions Solutions![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg)![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Solutions by Department](https://www.kintone.com/en-us/departments/) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Operations](https://www.kintone.com/en-us/departments/business-operations/) - [Sales](https://www.kintone.com/en-us/departments/sales/) - [Customer Support](https://www.kintone.com/en-us/departments/customer-support/) - [HR & Admin](https://www.kintone.com/en-us/departments/hr-admin/) - [Marketing](https://www.kintone.com/en-us/departments/marketing/) - [Manufacturing & Retail Management](https://www.kintone.com/en-us/departments/manufacturing-retail-management/) - [IT Support](https://www.kintone.com/en-us/departments/it-support/) - [Solutions by Function](https://www.kintone.com/en-us/functions/) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Convert spreadsheets to databases](https://www.kintone.com/en-us/functions/convert-spreadsheets-to-databases/) - [Data Management](https://www.kintone.com/en-us/functions/data-management/) - [CRM & Sales Management](https://www.kintone.com/en-us/functions/crm-sales-management/) - [Project Management](https://www.kintone.com/en-us/functions/project-management/) - [Workflow Management](https://www.kintone.com/en-us/functions/workflow/) - [Remote Work](https://www.kintone.com/en-us/functions/remote-work/) - [Recruitment & Hiring](https://www.kintone.com/en-us/functions/recruitment-hiring/) - [Solutions by Industry](https://www.kintone.com/en-us/industries/) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Manufacturing](https://www.kintone.com/en-us/industries/manufacturing/) - [Real Estate](https://www.kintone.com/en-us/industries/real-estate/) - [Retail](https://www.kintone.com/en-us/industries/retail/) - [Education](https://www.kintone.com/en-us/industries/education/) - [Hospitality](https://www.kintone.com/en-us/industries/hospitality/) - [Healthcare](https://www.kintone.com/en-us/industries/healthcare/) - [Nonprofit](https://www.kintone.com/en-us/industries/nonprofit/) - [Solutions by Problem](https://www.kintone.com/en-us/problems/) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Streamline Operations and Processes](https://www.kintone.com/en-us/problems/streamline-operations-and-processes/) - [Manage and Organize Business Data](https://www.kintone.com/en-us/problems/manage-and-organize-business-data/) - [Track Project Status and Accountability](https://www.kintone.com/en-us/problems/tracking-project-status-and-accountability/) - [Customer Stories](https://www.kintone.com/en-us/customer-stories/) - [Pricing](https://www.kintone.com/en-us/pricing/) - Resources Resources![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg)![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - [Webinars](https://www.kintone.com/en-us/events/) - [Guidebooks & Videos](https://www.kintone.com/en-us/guidebooks-and-videos/) - [Kintone Support Overview](https://www.kintone.com/en-us/support-overview/) - [Developers](https://kintone.dev/en/) - [Customer Resource](https://www.kintone.com/en-us/for-customers/) - [Blog](https://blog.kintone.com/business-with-heart?__hstc=181257784.34e49544339714832378568b4e02ab6c.1679463564667.1686561291068.1686624267650.55&__hssc=181257784.2.1686624267650&__hsfp=904488742) - Company Company![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_plus.svg)![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_back.svg) - - [About Us](https://www.kintone.com/en-us/company/) - [Careers](https://www.kintone.com/en-us/company/careers/) - [Press Center](https://www.kintone.com/en-us/press-center/) - [Contact Us](https://www.kintone.com/en-us/contact/) - ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_search_black.svg)![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_search_red.svg) Search Kintone ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_search_gray.svg) ![](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_login.svg)Log In [Get a Free Trial](https://www.kintone.com/en-us/trial/) [Get a Demo](https://resources.kintone.com/meetings/miri/kintonespecialist?__hstc=181257784.34e49544339714832378568b4e02ab6c.1679463564667.1686561291068.1686624267650.55&__hssc=181257784.2.1686624267650&__hsfp=904488742) - [![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-white.png) ![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-grey.png) ![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-red.png) Business with Heart <3](https://blog.kintone.com/business-with-heart) - [![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-white.png) ![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-grey.png) ![](https://blog.kintone.com/hubfs/2018%20S2/assets/kin-heart-red.png) Company + Product](https://blog.kintone.com/company-news) - Company + ProductLatest News from Kintone - [Company + ProductLatest News from Kintone](https://blog.kintone.com/company-news) - [Business with Heart <3Operations for the Digital First Team](https://blog.kintone.com/business-with-heart) ![Kintone How To's](https://blog.kintone.com/hubfs/How%20To%20Blog%20Image/3.png) [Tips and Tricks,](https://blog.kintone.com/company-news/tag/tips-and-tricks) # What is Conditional Formatting: A Free Add-On for your Kintone Experience May 23, 2019   |   by [Kevin Veloira](https://blog.kintone.com/company-news/author/kevin-veloira) [Tweet](https://twitter.com/share) **What is Conditional Formatting: A Free Add-On for your Kintone Experience ** **Add-ons** are packaged customization modules that Kintone users can install to their subdomains at the push of a button. We have multiple free add-ons available for our users, but in today’s blog post we’ll be taking a look at only one: a free add-on from Kintone Open Source called **Conditional Formatting**. To **[learn about how to install add-ons](https://blog.kintone.com/company-news/how-to-install-plug-ins-in-kintone)**, check out one of our previous past blog posts **[here](https://blog.kintone.com/company-news/how-to-install-plug-ins-in-kintone)**. And you can [view the full list of native Kintone plug-ins here](https://www.kintone.com/en-us/features/plugins/).   **Conditional Formatting** The Conditional Formatting add-on allows you to change the text color, background color, and text size of fields depending on the values of a specific field. This is a quick and easy way of adding an extra layer of organization to your fields. **To set up Conditional Formatting:** 1. **Verify which field-types this add-on can be applied to**. Note that not all field-types can be used with this add-on. 1. **To evaluate strings and numbers, use the following "Text conditional format" field-types:** - String (single-line) - Numeric value - Calculation - Radio button - Dropdown - Record number - String (multi-line) - Checkbox - Multi-choice - Status (Process management) (\*Reflects the record list window only) 2. **To evaluate dates, use the following "Date conditional format" field-types:** - Date - Date and time - Created on - Updated on 2. Adjust the following settings: 1. ****Field with Condition**:** Choose the field to be evaluated. If the value in this field meets the conditions you set, the target field will change its formatting. 2. ****Condition**:** This is the logical operator that will determine what relation the field with condition will have with its specified value. 3. ****Value**:** Enter the value needed in the field with condition. This is the value that will cause the field to format to change. 4. **Field to Format**: Once the conditions you have set are met, this is the target field that will have its font size, color, and background color changed. 3. Lastly, under **Font Color, Background Color, Font Size,** and **Style,** set how you want the field to format to be displayed with the change. 4. **Save** and **Update App**. You can see the changes on the record list screen or when viewing a record. There are a handful of other free add-ons from Kintone Open Source, so feel free to test them out and see which work for you! Check out the video below for more details! Have further questions? Please email [support@kintone.com](mailto:support@kintone.com). [![Kintone Free Trial CTA](https://no-cache.hubspot.com/cta/default/1857320/a0c9f62e-cc45-42e5-ade0-913fa2ddcd53.png)](https://cta-redirect.hubspot.com/cta/redirect/1857320/a0c9f62e-cc45-42e5-ade0-913fa2ddcd53) [![](https://blog.kintone.com/hubfs/Kevin.png)](https://blog.kintone.com/company-news/author/kevin-veloira) About the Author [Kevin Veloira](https://blog.kintone.com/company-news/author/kevin-veloira) Customer Success Specialist at Kintone. Kevin is the primary contact for Kintone users with account-based inquiries and native feature questions. Prior to joining Kintone, he worked as a public elementary and junior high school english teacher for three years in Kyoto, Japan. His hobbies include playing badminton, golf, listening to music, and checking out cool cafes and restaurants. Recommended Posts Up Next [June 2019 Product Updates](https://blog.kintone.com/company-news/june-2019-product-update) Previous [Tips on Writing an App's Description](https://blog.kintone.com/company-news/tips-for-an-apps-description) [Back to Company + Product Blog Page](https://blog.kintone.com/company-news) ### Subscribe to Blog #### Recommended Posts [![](https://blog.kintone.com/hubfs/AdobeStock_1035261718.png)](https://blog.kintone.com/company-news/build-your-ai-assistant-in-kintone) Digital Transformation ##### Build Your AI Assistant In Kintone Wouldn’t it be convenient to have an AI-powered chatbot that could answer questions about your app data in Kintone? For this use case, ChatGPT and other LLMs are promising, but not sufficient on their own. For consistently relevant results, retrieval of contex... [Read More »](https://blog.kintone.com/company-news/build-your-ai-assistant-in-kintone) [![](https://blog.kintone.com/hubfs/Zapier%20and%20Kintone%20integration.jpg)](https://blog.kintone.com/company-news/email-automation-kintone-zapier-1) Digital Transformation ##### Send Daily Emails to Closed Deals in Kintone via Zapier Often, we want to perform a series of actions on a set of business records. Our CRM database contains emails and other data we might need to process regularly. Whatever these records are (Deals, Leads, or Loans), we can use Zapier to perform a series of steps ... [Read More »](https://blog.kintone.com/company-news/email-automation-kintone-zapier-1) [![](https://blog.kintone.com/hubfs/Zapier%20and%20Kintone%20integration.jpg)](https://blog.kintone.com/company-news/email-automation-kintone-zapier) Digital Transformation ##### Email Automation in Kintone using Zapier Often, after an event in your CRM, it would be helpful to send an email automatically to a contact’s email address. This article will explain how to send an email to a customer’s Gmail or Outlook address when a record is created or when the Process Management ... [Read More »](https://blog.kintone.com/company-news/email-automation-kintone-zapier) [![](https://blog.kintone.com/hubfs/PSD%20app%20template%20thumbnail-Recovered.png)](https://blog.kintone.com/company-news/the-complete-guide-to-using-kintones-app-templates) Tips and Tricks ##### The complete guide to using Kintone's app templates If you’ve dabbled in Kintone’s free trial or even looked around our website, you’ve probably heard about the app templates. Kintone app templates are pre-built applications you can use to quickly get started building custom apps. Think of it like the framing o... [Read More »](https://blog.kintone.com/company-news/the-complete-guide-to-using-kintones-app-templates) ### Try Kintone For Free! Our clients have built and deployed over 340,000 Kintone applications. Join them by signing up for a free trial–no credit card required–or scheduling a customized product demo. [![Try Kintone for free](https://no-cache.hubspot.com/cta/default/1857320/38781637-01ae-4d81-a227-bf6704b72577.png)](https://cta-redirect.hubspot.com/cta/redirect/1857320/38781637-01ae-4d81-a227-bf6704b72577)[![Schedule a Live Demo](https://no-cache.hubspot.com/cta/default/1857320/97cabdc7-d654-44b7-bf14-68222b115553.png)](https://cta-redirect.hubspot.com/cta/redirect/1857320/97cabdc7-d654-44b7-bf14-68222b115553) [![Kintone](https://blog.kintone.com/hubfs/KintoneGlobal/svg/logo_kinton_black.svg)](https://www.kintone.com/en-us/) U.S. Cambodia China(中文) Hong Kong India Indonesia Korea Laos Malaysia Myanmar Philippines Singapore Taiwan(繁体字) Thailand Viet Nam Japan(日本語) Australia Fiji Kiribati New Zealand Papua New Guinea Samoa Solomon Islands Tonga Tuvalu Vanuatu - [![facebook](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_facebook.svg) ![facebook](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_facebook_color.svg)](https://www.facebook.com/kintoneusa) - [![twitter](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_x.svg) ![twitter](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_x_color.svg)](https://x.com/kintone) - [![LinkedIn](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_linkedin.svg) ![LinkedIn](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_linkedin_color.svg)](https://www.linkedin.com/company/kintoneusa/) - [![Instagram](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_instagram.svg) ![Instagram](https://blog.kintone.com/hubfs/KintoneGlobal/svg/icon_instagram_color.svg)](https://www.instagram.com/kintoneusa/) - [Terms of Use](https://www.kintone.com/en-us/terms-of-use/) - [Security](https://www.kintone.com/en-us/security/) - [Contact Us](https://www.kintone.com/en-us/contact/) - [Privacy Policy](https://www.kintone.com/en-us/privacy-policy/) - [Partners](https://www.kintone.com/en-us/partners/) Do Not Sell or Share My Personal Information - [Solutions by Department](https://www.kintone.com/en-us/departments/) - [Operations](https://www.kintone.com/en-us/departments/business-operations/) - [Sales](https://www.kintone.com/en-us/departments/sales/) - [Customer Support](https://www.kintone.com/en-us/departments/customer-support/) - [HR & Admin](https://www.kintone.com/en-us/departments/hr-admin/) - [Marketing](https://www.kintone.com/en-us/departments/marketing/) - [Manufacturing & Retail Management](https://www.kintone.com/en-us/departments/manufacturing-retail-management/) - [IT Support](https://www.kintone.com/en-us/departments/it-support/) - [Solutions by Function](https://www.kintone.com/en-us/functions/) - [Convert spreadsheets to databases](https://www.kintone.com/en-us/functions/convert-spreadsheets-to-databases/) - [Data Management](https://www.kintone.com/en-us/functions/data-management/) - [CRM & Sales Management](https://www.kintone.com/en-us/functions/crm-sales-management/) - [Project Management](https://www.kintone.com/en-us/functions/project-management/) - [Workflow Management](https://www.kintone.com/en-us/functions/workflow/) - [Remote Work](https://www.kintone.com/en-us/functions/remote-work/) - [Recruitment & Hiring](https://www.kintone.com/en-us/functions/recruitment-hiring/) - [Solutions by Industry](https://www.kintone.com/en-us/industries/) - [Manufacturing](https://www.kintone.com/en-us/industries/manufacturing/) - [Real Estate](https://www.kintone.com/en-us/industries/real-estate/) - [Retail](https://www.kintone.com/en-us/industries/retail/) - [Education](https://www.kintone.com/en-us/industries/education/) - [Hospitality](https://www.kintone.com/en-us/industries/hospitality/) - [Healthcare](https://www.kintone.com/en-us/industries/healthcare/) - [Nonprofit](https://www.kintone.com/en-us/industries/nonprofit/) - [Solutions by Problem](https://www.kintone.com/en-us/problems/) - [Streamline Operations and Processes](https://www.kintone.com/en-us/problems/streamline-operations-and-processes/) - [Manage and Organize Business Data](https://www.kintone.com/en-us/problems/manage-and-organize-business-data/) - [Track Project Status and Accountability](https://www.kintone.com/en-us/problems/tracking-project-status-and-accountability/) - [Customer Stories](https://www.kintone.com/en-us/customer-stories/) - [Pricing](https://www.kintone.com/en-us/pricing/) - [Native Kintone Plug-ins](https://www.kintone.com/en-us/features/plugins/) - [Intro to Kintone](https://www.kintone.com/en-us/intro/) - [Why Kintone](https://www.kintone.com/en-us/why-kintone/) - [Customer Stories](https://www.kintone.com/en-us/customer-stories/) - [Pricing](https://www.kintone.com/en-us/pricing/) - [How Kintone Works](https://www.kintone.com/en-us/how-kintone-works/) - [App Template Library](https://www.kintone.com/en-us/features/app-templates/) - [Extensions](https://www.kintone.com/en-us/features/extensions/) - [Native Kintone Plug-ins](https://www.kintone.com/en-us/features/plugins/) - [Kintone AI](https://www.kintone.com/en-us/features/ai/) - [System Administration](https://www.kintone.com/en-us/features/administration/) - [Security](https://www.kintone.com/en-us/security/) - [Webinars](https://www.kintone.com/en-us/events/) - [Guidebooks & Videos](https://www.kintone.com/en-us/guidebooks-and-videos/) - [Kintone Support Overview](https://www.kintone.com/en-us/support-overview/) - [Developers](https://kintone.dev/en/) - [Customer Resource](https://www.kintone.com/en-us/for-customers/) - [Blog](https://blog.kintone.com/business-with-heart) - [About Us](https://www.kintone.com/en-us/company/) - [Careers](https://www.kintone.com/en-us/company/careers/) - [Press Center](https://www.kintone.com/en-us/press-center/) - [Terms of Use](https://www.kintone.com/en-us/terms-of-use/) - [Privacy Policy](https://www.kintone.com/en-us/privacy-policy/) - [Partners](https://www.kintone.com/en-us/partners/) - [Contact Us](https://www.kintone.com/en-us/contact/) - Do Not Sell or Share My Personal Information © 2022 Kintone © 2022 Kintone