CODEWITHSUNDEEP
javascriptgoogle-apps-scriptgoogle-sheetsgs-conditional-formatting
user3424674
user3424674

Reputation: 69

Using google script to manipulate data conditional formating and data validation

I was looking for already 3 days but nowhere found how to manipulate those two tools by google script.

I am interested in maiking script runned dynamic creation of worksheets and fast edditing of worksheets.

I need to alter those: data validation and conditional formating which are available normaly on tool bar.

Please help, give me the name of class that consists of those or the functions in google script with little information I will find rest.

Thanks in adavance Tom

Upvotes: 0

Views: 156

Answers (2)

Eric Koleda
Eric Koleda

Reputation: 12673

Data validation can be set using Range.setDataValidation(). Unfortunately Apps Script doesn't support setting conditional formatting, but you can star this feature request to get notified if/when it's added.

Upvotes: 1

Martin Berends
Martin Berends

Reputation: 4178

The tools you are asking about appear to be in the Range class of the Google Apps Script Spreadsheet API. Note that the API calls deal with a range of cells at a time, although you can easily define a range that contains only one cell.

The question in its current form has nothing to do with Google App Engine, so consider taking that off the question tags.

Upvotes: 0

Related Questions