google sheets - is there a way to "instance" cell formatting?

user_16040481 0
Viewed 22

I have 2 sheets:

In Sheet1!A1:A is a list of values, the cells have formatting to color them appropriately.

In Sheet2!A1:A is the formula: "={Sheet1!A1:A}"

This instances the cell values, but not the formatting. Is there a way to get the formatting to carry through to sheet 2 also?

conditional-formatting google-sheets instance formatting arrays
1 Answers

you have only 3 options:

  • use script

  • hardcode the formatting with CTRL + C followed by CTRL + ALT + V

    enter image description here

  • or to setup Conditional formatting based on Sheet1

    (in this case you will need to reference Sheet1!A1 as INDIRECT("Sheet1!A1"))

user_56326290
Related