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.html > > > > 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 > > -- > 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 <http://www.americansentry.net> > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > -- My OpenOffice Calc Website http://www.openofficetips.com
