On Fri November 11 2005 20:38, David Chapman wrote: > You first need to create a 'blue' style that can be referenced in the > Conditional Formatting dialog.. I've actually just updated the tip with a > Flash animation showing how to do this.... > > On 11/11/05, John R. Sowden <[EMAIL PROTECTED]> wrote: > > Thanks-I found conditional formatting, keyed in the formula, changed the > > first > > drop down box to "formula is", but the second drop down box, cell style, > > shows > > "blue" in the sample's box, but the only options are "default, heading, > > heading2 result, result2". Now what? > > > > > > On Fri November 11 2005 18:58, David Chapman wrote: > > > > http://www.openofficetips.com/blog/archives/2005/03/conditional_for_3.htm > >l > > > > > On 11/11/05, John R. Sowden <[EMAIL PROTECTED]> wrote: > > > > I would like to make every other line a background pastel color to > > > > make > > > > > > reading spreadsheets easier. I would also like these to print as > > > > light gray > > > > (not a color) when I print them. Any help? I am surprised this is not > > > > an > > > > > > option in the format page dialog. > > > > -- > > > > --------------------------------------------------------------------- > > > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > -- > > > My OpenOffice Calc Website > > > http://www.openofficetips.com > > this is pretty fast interaction. I went to 'condition 1' at your site and created the style with the pain can. It appears that I must create a cell with the sample format. This sample format then becomes the 'style'. I think I got it. Oh, and Yipes! Stripes!
-- John R. Sowden AMERICAN SENTRY SYSTEMS, INC. Residential & Commercial Alarm Service UL Listed Central Station Serving the San Francisco Bay Area Since 1967 [EMAIL PROTECTED] www.americansentry.net --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
