I found the solution – WITHOUT a macro and listeners and shit…! I found it in one if the bug reports. It seems to be an undocumented feature. Here's the steps to success, please tell me if this does not work: 1. Create the different styles, named the same as the possible cell contents, I believe it was A, B, C and so on, right? 2. Highlight the cell range that you want to format conditionally. 3. In a cell range, one cell is selected. Make sure to remember which one it is. It has some kind of ”frame”, well you know… Let's say that it is A1 in this case. If it is another cell, then please change the formula below accordingly. 4. Format → Conditional formatting… → Condition 1: Change from ”Cell value is” to ”Formula is”. 5. In the field to the right, enter: IF(A1<>"";STYLE(A1)) 6. Leave everything else as it was. Click ”OK”. 7. Now, enter A in one of the cells in that cell range. Style A should now be applied to your cell! Problem's solved! Or is it? At least I think so, in this particular case. As I said, let me know if you still have problems. I tested this without creating any new styles. After all there are a few pre-defined, so I used them. I just input their names into a prepared cell and the corresponding style was immediately applied to that cell. Awesome! Best regards Johnny Rosenberg
Using suse 11.3 ooo from suse (probably gooo) it doesn't work --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
