On Thu, 2007-01-11 at 12:40 +0000, Dries Pruimboom wrote: > Hello List, > > I would like to set the cell color via the cell value, i know about the > conditional formatting feature, but i would like to do it in a smooth way. > What > i would like to do is something like this : > > CellBGColor=rgb(CellValue,0,255-CellValue) > > > When done by conditional formatting, this would mean 255 conditions and 255 > custom-styles with the colors.. . . not a really nice way of solving this. > > Can this be done ? > > Grtz Dries Pruimboom
Have a look at the STYLE function, it returns zero so it can be added to existing formula without affecting the result. Barrie --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
