Table formatter for boolean values

[Ryan]

Hello,

I have linked my google charts table to my google sheets and on my google sheet I have this:

It is achieved with conditional formatting.

When I display my table in google charts it changes my true and false to ticks and crosses, this means that it is recognised as boolean.

Is there a way I can apply a formatter to these values to match the behaviour above. I have tried this:

var boolFormat = new google.visualization.ColorFormat();
boolFormat.addRange(false, "", 'black', '#ff8787');

boolFormat.addRange(true, "", 'black', '#98d381');

boolFormat.format(data, 3);

But it doesn't work and I can't think of any other ways to achieve this.

Any help is greatly appreciated.

[DevOp42]

its a bit of a hack, but in the ready event you can modify the table:

google.visualization.events.addListener(Table, 'ready',function () {
   $TableTarget.find('.google-visualization-table-td-bool:contains("✗")').css('color', 'red');
   $TableTarget.find('.google-visualization-table-td-bool:contains("✔")').css('color', 'green');      
 });