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

Comments (6)

photo
1

Try SetBackgroundColor(A1, 0.9, 0.9, 0.9)


(A1:A6 is a copy of the cells)

photo
1

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

photo
1

Try the Execute() command together with Sequence()

photo
1

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.

photo
photo
1

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 + ?

photo
1

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

Thanks anyway

© 2023 International GeoGebra Institute