Macro for reformatting cells

[Guest]

I have a large grid with a different formula in every cell. at the end of
calculation, more than half of the cells will be a zero currency balance. I
want these cells to keep the formula but present a blank format. Is there a
macro or other way to achieve this? Thanks

 

[Guest]

Select Tools -> Options and on the View tab uncheck Zero Values

 

[Paul B]

Gina, one way, tools options, view, uncheck zero valves
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

 

[Guest]

Great! Thanks so much! I guess I need to spend more time checking out the
Tools>Options dialogue boxes -smile

 

[Guest]

Thanks Paul, that does the trick!

Gina, one way, tools options, view, uncheck zero valves
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003