Dries Pruimboom wrote:
I would like to set the cell color via the cell value, ... something like this
:
CellBGColor=rgb(CellValue,0,255-CellValue)
I don't think there is any way at all to set the color from a formula
other than the STYLE function and a defined style for each color. AFAIK,
even the API can't set the background color of a cell except by defining
a style with the desired color.
Conditional formatting is hard-wired to a maximum of three different styles.
You can (relatively) easily set up a lookup table to correlate a color
with a cell value or range, and you can have as many colors as you care
to define.
For more discussion, some examples and macros, see:
http://www.oooforum.org/forum/viewtopic.phtml?t=46282
http://www.oooforum.org/forum/viewtopic.phtml?t=47065
<Joe
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
