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!
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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.