Is it possible to add ConditionalFormatRule?

[manueljpeixoto]

I'm trying to add a conditionalFormatRule to a sheet/worksheet, and I'm unable to find a method to do this. Is it possible? If not, how can I change the color of a cell if that cell contains a certain value without running through all the cells?

[theoephraim]

Currently not supported, although it should be pretty straightforward to add support. See docs here: https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request#AddConditionalFormatRuleRequest and the method just waiting for someone to implement it :D https://github.com/theoephraim/node-google-spreadsheet/blob/master/lib/GoogleSpreadsheetWorksheet.js#L680