Adding background without conditional formatting

[MATTHEW450]

Is it possible to add a background color to a cell using HTML instead of conditional formatting? I would prefer using HTML when concatenating a bunch of cells together rather than add conditional formatting to a field I hope is always there. Thanks!

[Surya_Lakhani · Accepted solution]

Hi Matthew,

If you are concatenating data from multiple columns using "sharecol=true" you can add an empty column before that with the text mode like:

valueformat=HTML
shortview=false
value=<p style="background-color:DodgerBlue;">
textmode=true
sharecol=true

It should merger the columns and add the color for the entire cell.