Conditional formatting can not be recognized directly from your data source, but it is possible to implement a color dynamic for the cells in your app.
We have created a small demo app showing this feature: https://oaa.app.link/launch-app-21d9ca6c-130e-49b1-8dea-f2cfdb61a832
Currently, this feature is available for output cells.
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:
- In the Web Portal, open the editor for the output cell in which you want to insert the dynamics.
- Go to the "Advanced" tab.
- Add the definition "backgroundcolorcell=WorksheetName!Cell;".
- Save your changes and update your app.
In the Demo App it's "backgroundcolorcell=Tabelle1!C7;". The element will be colored after the color code in cell C7 on Sheet "Tabelle1".
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.