"How to use a formula to change a row background color."

"What do I need before I start?"

" You have completed the tutorial for the SAP Build CodeJam, Implement Spinner for Product Details Page. "

15 - Implement Conditional Formatting to Change Color Based on Data

Amend the shopping cart page - to highlight any items that have a Unit Quantity of 50 or higher – as part of the SAP Build CodeJam.

🎓beginner ⏱15 min SAP Build Beginner SAP Business Technology Platform SAP Build Apps SAP Build Process Automation 0/2

Overview

🎓 beginner ⏱ 15 min. SAP BuildBeginnerSAP Business Technology PlatformSAP Build AppsSAP Build Process Automation

You will learn

✔How to use a formula to change a row background color.

I Ian Thain December 4, 2025

Created by January 2, 2025

Contributors

Prerequisites

You have completed the tutorial for the SAP Build CodeJam, Implement Spinner for Product Details Page.

Steps

Open all Close all

Intro

In this exercise, you will be enhancing the Cart page of the SAP Build CodeJam app with data and functionality.

Specifically, you will change the background color of the row showing the cart entries. If the quantity ordered is less than 5 the color will be white, and if it is 5 or more the background color will be changed to amber.

Step 1 Amend the Cart Page

—

Open the Cart page.
Select the Row - Items component.
Row - Cart Item
In the Style tab, click on the Background color, likely set to Home.
Background color
Select the NEW PALETTE item.
New Palette Item
Select Formula.
Edit Formula
Then click the existing formula, which is just a string representing a color.
Open formula editor
Enter the following formula:
JavaScript
```
IF(repeated.current.quantity > 4, "#f0ab00", "#f7f7f7")
```
Edit Formula
Click Submit, and then save your formula by clicking Convert.
Edit Formula
Click Save (upper right).