Background color spreadsheet

kberhib shared this question 2 years ago

Needs Answer

Hi there!

I am trying to set the backgroud color for a range of cells in the spreadsheet to light gray for example to (0.9,0.9,0.9) The toolbar give some options, but only quite dark colors. There is also a button there labeled + wich I thought would open a window with more options, but when I click it nothing happens (Classic 6 for mac). Is this a bug?

I have also tried SetBackgroudColor(A1:B6, 0.9, 0.9, 0.9) without success.

Any tip?

Best regards,

Ketil Bergesen

The same question

Comments (6)

Michael Borcherds ● 2 years ago

Try SetBackgroundColor(A1, 0.9, 0.9, 0.9)

(A1:A6 is a copy of the cells)

Reply URL

kberhib ● 2 years ago

Thank you, but that will give background color to a single cell. I have about a hundred cells in a rectangular range of cells I would like this to apply to...What about the plus sign in the menu for changing the background color of a range of cells, what function is it intended to have (see the attached screenshot)

Best regards!

Ketil B

Files: Screenshot 2021...

URL

Michael Borcherds ● 2 years ago

Try the Execute() command together with Sequence()

URL

kberhib ● 2 years ago

Thanks, I have tried and tried, but get nowhere, I simply can not address a cell dynamically, like "A"+i, where i runs through some integers.

URL

mathmagic ● 2 years ago

Or use version 5

also

What about the plus sign in the menu for changing the background color of a range of cells, what function is it intended to have

perhaps x instead + ?

Reply URL

kberhib ● 2 years ago

I don't know, but the plus button does nothing...(except erasing the background color if it has one

Thanks anyway

Reply URL