Brian Barker <[email protected]> wrote: >Perhaps explain what you tried, what you expected to happen, and what >actually happened? Otherwise, anyone can only guess. Okay, here goes in painful detail. I wanted several custom styles to highlight values in a range that could be considered to be outliers relative to the other values in that range. Sample cell contents: A1 2.5 B1 "Sale" C1 "Commission" D1 "Miles" A2 "μ" B2 =AVERAGE(B4:B2003) C2 =AVERAGE(C4:C2003) D2 =AVERAGE(D4:D2003) A3 "σ" B3 =STDEVP(B4:B2003) C3 =STDEVP(C4:C2003) D3 =STDEVP(D4:D2003) Formatting of numbers: Column B $0.00 Column C $0.0000 Column D 0.0 Custom Styles: Style Outlier_B: Same as column B except with special display effects Style Outlier_C: Same as column C except with special display effects Style Outlier_D: Same as column D except with special display effects Conditional formatting using Format→Conditional Formatting→Condition… : Range B4:B2003 Formula is AND(ISNUMBER(B4),OR(B4<(B$2-$A$1*B$3),B4>(B$2+$A$1*B$3))) Apply Style Outlier_B Range C4:C2003 Formula is AND(ISNUMBER(C4),OR(C4<(C$2-$A$1*C$3),C4>(C$2+$A$1*C$3))) Apply Style Outlier_C Range D4:D2003 Formula is AND(ISNUMBER(D4),OR(D4<(D$2-$A$1*D$3),D4>(D$2+$A$1*D$3))) Apply Style Outlier_D Now my problem is that I want to change the special display effects. I press F11. I see a small panel ("Styles and Formatting"). There are five icons at the top (two on the left and three on the right. The icon images mean nothing to me but fortunately each has a tool tip. Left side ° Displays the list of the available Cell Styles for indirect cell formatting. ° Displays the Page Styles available for indirect page formatting. Right side ° Turns the Fill Format mode on and off. Use the paint can to assign the Style selected in the Styles and Formatting window. ° Creates a new style based on the formatting of a selected object. ° Updates the Style selected in the Styles and Formatting window with the current formatting of the selected object. The body of the panel displays: Default Heading Heading1 Outlier_B Outlier_C Result Result2 The bottom of the panel says All Styles but can be any of: Hierarchical All Styles Hidden Styles Applied Styles Custom Styles With All Styles selected the context menu for the standard five styles is ° New … ° Modify … ° Hide and for my custom styles ° New … ° Delete … In the Hidden Styles view there is one style listed. It is not listed in the All Styles list. Its context menu is ° New … ° Modify … ° Show ° Delete … The Applied Styles list is empty. The Custom Styles list has my three custom styles with the same context menu as before. My problem is that my custom styles don't have Modify … on the context menu. Delete … does appear to work though the deleted style reappears later. My custom styles were created within the _new_ Conditional Formatting dialog box which, by the way, does not appear to be documented in the Help list. LO 4.1.3.2 Kubuntu 13.10 -- Jim -- To unsubscribe e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
