copying "blank" cells

on sheet1, a range 60 x 7 cells, all condtionally formatted but not all used
(i.e. data content may be blank).

Want the exact range onto sheet 2 (i.e. A1: G70 on sheet2
("=sheet1!A1:G70)") which works to a degree - have got the conditional
format OK on all cells.
All the "filled" data cells copy over correctly, but the "blank" data
content becomes "0" (I need it blank)

How to make blank cells on sheet 2 = blank cells on Sheet 1, still
conditionally formatted
(conditional format is text/font display if a numeric condition is met) ?

Hi Silvabod,

Perhaps - Tools>Options>View tab and uncheck "zero values"

You could change your formulae from:

=sheet1!A1

to:

=IF(sheet1!A1="","",sheet1!A1)

then copy across and down.

Hope this helps.

Pete

Martin, Pete - thanks! Am tied up with something else, but will try ASAP -
I'm sure you're both right! (Excel seems to have multiple solutions).

"Silvabod" <nospam@thank.you> wrote in message
news:ZF33g.13115$E12.4802@newsfe6-gui.ntli.net...
> on sheet1, a range 60 x 7 cells, all condtionally formatted but not all
> used (i.e. data content may be blank).
>
> Want the exact range onto sheet 2 (i.e. A1: G70 on sheet2
> ("=sheet1!A1:G70)") which works to a degree - have got the conditional
> format OK on all cells.
> All the "filled" data cells copy over correctly, but the "blank" data
> content becomes "0" (I need it blank)
>
> How to make blank cells on sheet 2 = blank cells on Sheet 1, still
> conditionally formatted
> (conditional format is text/font display if a numeric condition is met) ?
>
>
>

Martin, tried this first - exactly right, and quick!
(just one tick removal in "view" did it all).
"MartinW" <mtmw@hotmail.invalid> wrote in message
news:eSjHFD6ZGHA.3704@TK2MSFTNGP03.phx.gbl...
> Hi Silvabod,
>
> Perhaps - Tools>Options>View tab and uncheck "zero values"
>