Solved: Left zero to appear as blank

[sujittalukde]

In the attached workbook, my problem is that all the Zeroes should be blank untill a value is found.In actual case, the figures in the cells are actually broken from some other cells and as such the blank should come by way of formulas in the cells having zero

The left zeroes should be blank untill a value >0 is found in next cell

Hoe this can be done? Any suggestion?

[zv735]

Select Number Cell thai u want
in this case i use B14 to I16

and then use Condition Formating in Format manu
select by Formula

Type

=SUM($B14:B14)<=0

select Font format is white Color

then OK

see att file

Thank you

[Bob Phillips]

You could use conditional formatting

[sujittalukde]

I was trying for the same but never succeed. Now the matter has been solved. Many Many thanks for the solution.