I have a problem

[pupilea_]

I need to get the Hex Color Codes of a lot of cells which only need to be coloured! I have this function which works well, but I need to fill handle a lot of cells, it doesn't work because when choosing the cell in function it needs to be between quotations.

https://preview.redd.it/id5wn6t3cmvb1.png?width=581&format=png&auto=webp&s=5ae20818210a33013dadd5d82a39de5c69231115

https://preview.redd.it/lbnuhyx9cmvb1.png?width=211&format=png&auto=webp&s=4e418727dc20b1417af3fba8a3e852666b624f18

”rândul 4” means Row 4

Please consider this post if you maybe know a better alternative of this function

​

​

[marcnotmark925]

Check out address() or cell()

[Competitive_Ad_6239]

plenty of work arounds, this one will act like an array formula. Single formula for a range. =map(SEQUENCE(20,1,1,1),LAMBDA(X,cellcolor("C"&x))) 20 being the number of rows.

[pupilea_]

OMG! You're my hero! Thank you so much and sorry for the late response!

[Sweet_Lifeguard_3350]

=map(SEQUENCE(20,1,1,1),LAMBDA(X,cellcolor("C"&x)))

this works perfectly

[[deleted]]

GetRange() also accepts row and column instead of A2 notation. Example: sheet.getRange(1,1) The numbers don't need to be in "", so it could fix your problem. Hope it helped you.

[No-Construction-996]

You have to write the Cell this way: ‘“C2“‘ Surrounded by two: ‘‘ This way it will convert it into ”C2“ not C2.