CODEWITHSUNDEEP
google-apps-scriptgoogle-sheets
wjp79
wjp79

Reputation: 149

Google sheet borders based on backgroundcolor

Since conditional format does not allow setting borders, is it possible to create a script and border a row based on the color of a cell / row?

If so how?

I found similar scripts, but no scripts based on background color. I need something to get started / push in the right direction....

Upvotes: 0

Views: 95

Answers (1)

Iamblichus
Iamblichus

Reputation: 19339

You can use Range.getBackground() to get the background color from one cell, or Range.getBackgrounds() to get the background colors from multiple cells.

You can then use that information to set your desired borders, using Range.setBorder.

Upvotes: 1

Related Questions