Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro for reformatting cells
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro for reformatting cells
Select Tools - Options and on the View tab uncheck Zero Values
-- HTH... Jim Thomlinson "Gina_Louisville" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro for reformatting cells
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 "Gina_Louisville" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro for reformatting cells
Great! Thanks so much! I guess I need to spend more time checking out the
ToolsOptions dialogue boxes -smile "Jim Thomlinson" wrote: Select Tools - Options and on the View tab uncheck Zero Values -- HTH... Jim Thomlinson "Gina_Louisville" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Macro for reformatting cells
Thanks Paul, that does the trick!
"Paul B" wrote: 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 "Gina_Louisville" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
Macro to delete a group of CELLS | Excel Discussion (Misc queries) | |||
Cells turn 'hot' and execute distant macro button | Excel Discussion (Misc queries) | |||
checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
Closing File Error | Excel Discussion (Misc queries) |