Skip to main content
MATTHEW450
MATTHEW450
Level 2
Jan 5, 2023 4:56 PM UTC
Solved

Adding background without conditional formatting

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!

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
SuryaLakhani
SuryaLakhaniAccepted solution
Level 4
Jan 27, 2023 6:10 PM UTC

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.

View in thread

1 reply

SuryaLakhani
SuryaLakhaniAccepted solution
Level 4
Jan 27, 2023 6:10 PM UTC

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.

Translate
    Terms & ConditionsAccessibility statement

    Loading footer...