Another option (in M$ Excel) is "Data Validation" which forces the user to leave a cell blank or select from a drop down list (which is held in a hidden column). Haven't done this in OOo.
> -----Original Message----- > From: Mark Knecht [mailto:[EMAIL PROTECTED] > Sent: Thursday, August 21, 2008 11:41 AM > To: [email protected]; [EMAIL PROTECTED] > Subject: Re: [users] Cell formatting question > > Anthony, > Thanks. That does seem to be what he did. In his spreadsheet the > cell evaluates to 'Option 0'. In another cell elsewhere ($B$99) he > wrote out 'Option 0' and on this cell he has conditional formatting > such that if this cell has the same text as $B$99 then the font is > written in the background color. This way the cell displays when some > value comes up other than 0 but is clean when 0 is the number. Nice. > > Thanks again for your help. You seem to be around a lot when I have > these questions. I appreciate it! > > Cheers, > Mark > > On Thu, Aug 21, 2008 at 9:08 AM, Anthony Chilco > <[EMAIL PROTECTED]> wrote: > > Hi Mark, > > The author of the original spreadsheet probably used conditional > formatting. > > The cell is hidden if M33 is zero. > > tc > > > > Mark Knecht wrote: > >> > >> Hi, > >> I'm looking at a prebuilt spreadsheet in Excel and trying to > >> duplicate some of its functionality in OOCalc. I'm having trouble > with > >> one formatting issue. In Excel there is a cell that has the > following > >> contents: > >> > >> ="Option "&M33 > >> > >> M33 is a cell that contains a number from 0-160. In Excel when M33 > is > >> 1 or greater Excel displays > >> > >> Option 1 > >> > >> or whatever number is in cell M33. However when M33 is 0 Excel > >> displays nothing. The cell is completely blank. It does not say > Option > >> 0. > >> > >> When I try to build this myself, in Excel or OOCalc I see Option 0 > >> in my version. How did the guy who created this spreadsheet get > Excel > >> to do this? > >> > >> I've checked all the formatting for the cell and I just don't see > it. > >> > >> Thanks, > >> Mark > >> > >> -------------------------------------------------------------------- > - > >> To unsubscribe, e-mail: [EMAIL PROTECTED] > >> For additional commands, e-mail: [EMAIL PROTECTED] > >> > >> > >> > > > > > > --------------------------------------------------------------------- > > To unsubscribe, e-mail: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
