Conditional formatting: putting 0 when the cell is blank doesn't work

[Vitalite]

Hello!

My goal is to put 0 (or - ) into a cell in column B whenever the cell is blank (doesn't contain anything) and when the cell refers to subtasks (values in column A contain dots).

I tried to formulas, none do the job correctly - they skip blanks, don't put zeros, etc.

=IF(AND(MOD($A$3:$A15,1)>0,$B3=""),0,$B3)

=IF(AND(MOD($A$20:$A28,1)>0,ISBLANK(B22)),0,$B12)

I will be grateful for your help.

I am also attaching a file.

Thank you!

[AliGW]

You can't add values to cells using conditional formatting.

[Vitalite]

How can I replace blank cells with zero values then, if I have accounting format in cells?

[AliGW]

Try this custom number format:

0;-0;-

This will produce the following:

1 for positive values

-1 for negative values

- for zero values

[Vitalite]

Try this custom number format:

0;-0;-

This will produce the following:

1 for positive values

-1 for negative values

- for zero values

This is not suitable for my purposes. I use an accounting formatting, and it has a way more complicated code as I see when I open a formatting window.

[AliGW]

OK - but all I have done is adapted that code, you see? I thought that you wanted to replace 0 values with a simple dash. What would be really helpful is if you would simply state what you have got now (not formulae, but cell values) and what you want it to be. Your attachment really doesn't make that clear. Also, if your 'purpose' is relevant, then state it!

[AliGW]

Maybe this is what you want?

_-$* #,##0_-;-$* #,##0_-;-

In other words, just replace the third criterion in the format code to -.

[AliGW]

Are we there yet?

[shukla.ankur281190]

How can I replace blank cells with zero values then, if I have accounting format in cells?

If you want to put Zero in blank cell, select the range press control+G->special->Check mark on blank->> All the blank cells will be select ->> put 0 and press control+Enter.