Format individual cells

Wouter de Schepper · 2023-08-07T12:49:24+00:00

There was an error rendering this rich post.

Dear All,

I have a question regarding formatting individual cells, is it possible to color a individual cell eg. if value is negative → green, if value is positive → red. I know the option color alert, but this has effect on the total column.

Is it possible to format individual values in a row/column?

Regards,

Wouter

Find more posts tagged with

Accepted answers

Giles Corner

Hi Wouter,

If I understand your question correctly you're looking to use alerts (conditional formatting) but with different logic dependent on the row. i.e. if the Country is Italy, green if value is greater than 15m.

This can be done using the alert function and a nested IF() statement.

1. Add the entity that is shown on the row as an entity block in the layout so it can be referenced in the IF statement (this block can be hidden
2. Build your IF statement logic, this could use the AND() OR() operators. The output of the IF statement should be different values depending on the colours you want to use for the formatting
3. Configure the Alert on the block you want to colour, this should be based on the algorithm block you have built in step (2)

All comments

Samson Sunny

Hi Wouter,

You can use the "Row Template" feature in the Data View properties to set the cell background/foreground color for single entities or single members of an Entity.

The Board manual has more on the row templates:

https://www.boardmanual.com/2021/summer/data-modeling/2_Database_design_functions/13_Format/format.htm?rhhlterm=templates%20template&rhsearch=templates

https://www.boardmanual.com/2021/summer/whats-new-release-notes/2023-spring-release/main-features/custom-style-templates.htm?rhsearch=templates&rhhlterm=templates%20template%E2%80%9D%20template%20%E2%80%9Ctemplates%E2%80%9D

Thanks,

Samson.

Wouter de Schepper

Thank you Sir! Is it also possible to make different conditions (conditional formatting) for individual cells?

Samson Sunny

Yes you can use the 'Row Template' feature to apply conditional formatting on individual cells.

Once the individual cell is selected you can apply the different formatting options :

Thanks,

Samson.

Giles Corner