Ask Your Question

CALC: how to copy style from a cell to another one

asked 2017-01-31 12:05:42 +0100

marcopic gravatar image

I have a table with two columns: one for text and one for numbers (numbers and text are related to one another) I have created a conditional color gradient for column of numbers Now I want to copy the style of that column in the column of text so the cells of each row has the same style.

How can I do?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-31 14:57:41 +0100

karolus gravatar image


There is no way to extend this special kind of CF to Neighbour-Columns, not in GUI nor through the API.

You have to reimplement the whole Functionality by Script bound to Sheet-event →→Content changed

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-31 12:05:42 +0100

Seen: 126 times

Last updated: Jan 31 '17