Colour Formatter

[Leah Pike]

I would like to set up a colour for when a cell contains no data within the data table.

I have tried setting the from and to range to null, but it seems to match on everything, not just empty data.

Is it possible to do this?

var formats = [];
formats.push({
 color: 'black',
 bgcolor: 'red',
 from: null,
 to: null
});