1. On ‘My Reports’ view, open the report you would like to change. You can directly click on ‘Add/Edit Columns’ button or click on ‘Edit Reports Data’ and open ‘Add/Edit Column’ tab.
2. On ‘Available Columns’, search the one called CONDITIONAL_FORMATTING.
The formula should be placed in the blank space in the right column.
Example
Adding the following formula will allow you to color code the rows by transaction type: BY, SL, CS, and SS.
The formula:
IF([[T_TRANSACTIONTYPE]]=’BY’, ‘RowFormat1’,
IF ([[T_TRANSACTIONTYPE]]=’SL’, ‘RowFormat2’,
IF ([[T_TRANSACTIONTYPE]]=’CS’, ‘RowFormat3’,
IF ([[T_TRANSACTIONTYPE]]=’SS’, ‘RowFormat4’ , ‘RowFormat5’))))
3. Now that we have added the formula, we click on Spark button and then ‘Application’
4. Click on ‘General Settings’ and scroll down until ‘ConditionalFormatting. There, you can edit the format of each transaction row. The submenus ‘RowFormat1’, ‘RowFormat2’, ‘RowFormat3’, and ‘RowFormat4’ attend to the format of the transactions stated in the previous formula.
Now we can add on each section the configuration that we wish. If we want a gradient color, we will set up different colors in ‘BackgroundStart’ and ‘BackgroundEnd’. We will choose the same one in both if a flat color is what we want.
Now we can see the report with the colors that we chose!
