Calc colour
Would this be the appropriate place to posit a Calc query, please?
If I set the background colour in one cell - say cell A1 - to Red and then in another cell - say B1 - I enter the text #ff0000 (the rgb code for red) and then from a macro elsewhere change the text in cell B1 to #0000ff (the code for Blue) can that be used to change the A1 background colour to Blue?
Or to put it slightly differently, does each cell in a Calc spreadsheet have a background.color property which can be changed by programming?
If I set the background colour in one cell - say cell A1 - to Red and then in another cell - say B1 - I enter the text #ff0000 (the rgb code for red) and then from a macro elsewhere change the text in cell B1 to #0000ff (the code for Blue) can that be used to change the A1 background colour to Blue?
Or to put it slightly differently, does each cell in a Calc spreadsheet have a background.color property which can be changed by programming?