blanking out the number zero

M

manickmj

Hello I probably have and easy problem,

What I need is to add to a formula that if the answer to the formula i
zero (0) to make the cell blank. I curently have an easy formula i
the cell...it is only---> =COUNTIF('Weegee Begin o
Month'!$D$2:$R$2,"s"). the purpose is to count the sick days o
payroll. I am afraid the payroll form is going to be too busy with al
the zeros on the form. it would be better if they were blank.


thanks
mik
 
C

cincode5

Short of modifying your fomula to use a "" if the value is zero, use Conditional Formatting for all the cells you want to mask. Go to Format in the Menu Bar and select Conditional Formatting. "Cell Value Is", "eQUAL tO"
 
C

cincode5

Sorry I accidently hit Post.

Conditional Format, "Cell Value Is", "equal to", 0
Then in the Format section, Set your Font Color to match the background color of the cell its in.

You can apply this Conditional Format to all other cell by selecting the cell you just 'conditioned' and dragging you mouse over all the other cells you want to be alike. Then go into select Conditional Formatting again and hit 'OK'


F
 
E

Earl Kiosterud

Mike,

You can use Tools - Options - View - Zero values (unchecked). This is on a
sheet by sheet basis, so have the sheet selected. It affects all the cells
in the sheet. If you need this only for certain cells, you can instead use
Format - Cells - Number with a custom code like

General;General;
0.00;-0.00;
 
Top