Formatting cells - help! work in progress

Posted by mike kleimeyer on April 17, 2001 8:36 AM

I need to format, lets say cell A1 and B1, where the formula in cell b1 is "=A1". I need B1 to be equal to zero if a zero is placed in a1 however, I need B1 to be blank if a1 is blank.

So I need a very simple way to have a blank cell not be recognized as a zero. I would prefer this be done as a format rather than changing the B1 formula such as an IF statement.

Thanks in advance

Posted by Ian on April 17, 2001 11:34 AM

I'm sure you must have a good reason not to use the if statement, since that would seem to be the easiest way. The only I can think of is with conditional formatting. I should say I know zero about VBA too.
While in B1 go to format conditional formats. Set the formula to =A1="" and choose a color similar to your background as both the highlight and text color. Granted, this is pretty lame, but it could work.

Good luck.