--- title: Conditional formatting of the background color description: Control the background color of an element depending on a value. --- [Skip to content](https://help.openasapp.com/conditional-formatting-of-the-backgroundcolor#main-content) - [English](https://help.openasapp.com/conditional-formatting-of-the-backgroundcolor) - [Deutsch](https://help.openasapp.com/de/bedingt-formatieren) English Show submenu for translations [Submit Request](https://help.openasapp.com/kb-tickets/new?hsLang=en) ![ISO white logo@4x.png\]](https://help.openasapp.com/hs-fs/hubfs/ISO%20white%20logo@4x.png?height=31&name=ISO%20white%20logo@4x.png) - [This is possible](https://www.openasapp.net/home/wasgeht.html) - Product - [Apps](https://www.openasapp.net/portal#!/appCatalog) - Resources Show submenu for Resources - [Blog](https://cms.openasapp.com/blog) - [Blog Deutsch](https://info.openasapp.com/blog-de) - [Support](https://support.openasapp.net/hc/) Open main navigation Close main navigation - [This is possible](https://www.openasapp.net/home/wasgeht.html) - Product - [Apps](https://www.openasapp.net/portal#!/appCatalog) - Resources Show submenu for Resources - [Blog](https://cms.openasapp.com/blog) - [Blog Deutsch](https://info.openasapp.com/blog-de) - [Support](https://support.openasapp.net/hc/) - - [English](https://help.openasapp.com/conditional-formatting-of-the-backgroundcolor) - [Deutsch](https://help.openasapp.com/de/bedingt-formatieren) English Show submenu for translations - [Submit Request](https://help.openasapp.com/kb-tickets/new) - [Open as App](https://openasapp.com/) [Open as App](https://openasapp.com/) Hello. How can we help you? - There are no suggestions because the search field is empty. 1. [Help Center](https://help.openasapp.com/?hsLang=en) 2. [CREATION](https://help.openasapp.com/creation?hsLang=en) 3. [Excel & Sheets](https://help.openasapp.com/creation?hsLang=en#excel-sheets) # Conditional formatting of the background color ## Control the background color of an element in depending on a value. We have created a small demo app showing this feature: [https://oaa.app.link/launch-app-21d9ca6c-130e-49b1-8dea-f2cfdb61a832](https://oaa.app.link/launch-app-21d9ca6c-130e-49b1-8dea-f2cfdb61a832) **Note:** Conditional formatting can not be recognized directly from your spreadsheet, but it is possible to implement a color dynamic for the cells in your app. The first step is to edit your Excel and define a cell that will later specify the color of the item in your app. In Excel you can define the shown color code by a simple IF THEN formula (as shown in the example file attached). Then, you need to edit the element of the app and tell it to take the background color value from this specific cell in Excel. This cell contains the HEX color value (for example: #ffffff) and the element will recolor accordingly To add "conditional formatting" of the background color, proceed as follows: 1. In the Web Portal, open the editor for the output cell in which you want to insert the dynamics. 2. Go to the **"STYLE"** tab. 3. **Background Color Cell:** Add the cell with the color code. 4. Save your changes and update your app. ![](https://help.openasapp.com/hubfs/image-png-Aug-12-2022-01-52-07-31-PM.png) The data source for the app shown in this example can be found in the appendix below. The logic for the color definition comes from the Excel. The app reads the color value from the cell and adapts accordingly. - [conditional-formats.xlsx](https://support.openasapp.com/hc/en-us/article_attachments/115002234864/conditional-formats.xlsx)         - [CREATION](https://help.openasapp.com/creation?hsLang=en#main-content) - [Introduction](https://help.openasapp.com/creation?hsLang=en#introduction) - [Excel & Sheets](https://help.openasapp.com/creation?hsLang=en#excel-sheets) - [Basics](https://help.openasapp.com/creation?hsLang=en#basics) - [APP and Page Settings](https://help.openasapp.com/creation?hsLang=en#app-and-page-settings) - [Elements](https://help.openasapp.com/creation?hsLang=en#elements) - [FAQs](https://help.openasapp.com/creation?hsLang=en#faqs) - [APP SHARING & USER MANAGMENT](https://help.openasapp.com/app-sharing-user-managment?hsLang=en#main-content) - [App Sharing](https://help.openasapp.com/app-sharing-user-managment?hsLang=en#app-sharing) - [User Management](https://help.openasapp.com/app-sharing-user-managment?hsLang=en#user-management) - [FAQs](https://help.openasapp.com/app-sharing-user-managment?hsLang=en#faqs) - [CLIENT](https://help.openasapp.com/client?hsLang=en#main-content) - [iOS, Android & Web Client](https://help.openasapp.com/client?hsLang=en#ios-android-web-client) - [Embedded App](https://help.openasapp.com/client?hsLang=en#embedded-app) - [FAQs](https://help.openasapp.com/client?hsLang=en#faqs) - [TUTORIALS](https://help.openasapp.com/tutorials?hsLang=en#main-content) - [Videos](https://help.openasapp.com/tutorials?hsLang=en#videos) - [ACCOUNT & BILLING](https://help.openasapp.com/account-billing?hsLang=en#main-content) - [Account](https://help.openasapp.com/account-billing?hsLang=en#account) - [Billing](https://help.openasapp.com/account-billing?hsLang=en#billing) - [DATA PRIVACY AND SECURITY](https://help.openasapp.com/data-privacy-and-security?hsLang=en) - [This is possible](https://www.openasapp.net/home/wasgeht.html) - Product - [Apps](https://www.openasapp.net/portal#!/appCatalog) - Resources - [Blog](https://cms.openasapp.com/blog) - [Blog Deutsch](https://info.openasapp.com/blog-de) - [Support](https://support.openasapp.net/hc/) [![Chill listening crop-3](https://help.openasapp.com/hs-fs/hubfs/horizontal%20solid%20logo.png?width=125&height=36&name=horizontal%20solid%20logo.png "Chill listening crop-3")](https://openasapp.com/) Copyright © 2026, Open as App GmbH