Claudia Drechsle wrote at 12:21 on 17 Jul 2006: > Hi James > > > What am I doing wrong? Are borders something that cannot be defined via > > the conditional formatting mechanism? Other conditional formatting > > triggered by the very same formula but used only to set fonts and/or > > background colors work just fine. > > > I can only tell you the same experience. I once tried to insert horizontal > lines in a list to give the long list a structure. I used a column that > represented a sort of chapter-number and the condition I applied was: when > the chapter-number is not the same than the chapter-number of the cell > above, use style XX, which had borders only on top of the cell. > It did not work, not with "conditional formating" and not using the formula > +STYLE() / &T(STYLE()) > I finally changed and used background-colored styles. That worked but needed > a different organisation > greetings
Thank you, Claudia. I'm getting to the point where I believe that this functionality does not exist in OOo Calc. I don't know whether Excel has it or not so I don't know whether this is a compatibility issue. I realize that if it is not then the likelihood of getting it changed is remote. I'll give up on this particular styling issue before I change to narrow rows or columns to simulate borders. There is just way too much baggage associated with that approach. I find the Help for conditional formatting to be overly simplistic. *Maybe* I'll find time to contribute to the OOo project in this area. -- Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
