I am using Calc from the Novel Edition of OpenOffice.org 2.0 (build 2.0.0.1).
I want to eliminate all borders in certain cells when another cell contains the text "Special Case" and in order to accomplish this, I defined a style "borderless" using a blank cell in which I had eliminated all borders. In cell AN2 I normally have 4.00 pt automatic color borders top and left. In that cell I selected "Conditional formatting ..." from the "Format" menu. I then selected Condition 1 Formula is AK38="Special Case" and Cell Style borderless yet when cell AK38 contains the text "Special Case" the 4.00 pt automatic color borders top and left remain. These borders are *not* the result of adjacent cells. 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. -- Jim --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
