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]
