WITH_BACKGROUND_COLOR

A data.world specific function for controlling the formatting of query results. Cells with WITH_BACKGROUND_COLOR specified will be displayed with the selected color in data.world query results. For any other uses (e.g. export to CSV or API access), the WITH_BACKGROUND_COLOR specification is ignored

Parameter	Type
`value`	string, formattedtext
`color`	color

Returns: formattedtext

Example

query:

SELECT WITH_BACKGROUND_COLOR("dave", COLOR("#90B1D5")) as name

siyeh/sql-crm-example-data Run query Copy code

results:

name
dave